Use One Excel Slicer to Filter PivotTables from Multiple Tables
Question details
The user needs one slicer to filter three PivotTables and their PivotCharts using all unique Nomenclature values from three Excel tables.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Three separate source tables each feed a PivotTable and PivotChart that use a Nomenclature field.
- Observed behavior
- Report Connections does not provide the required connections between the slicer and all three reports.
Confirm that each source table has a Nomenclature column with consistently formatted values. You need an Excel version that supports the Data Model, relationships, and Power Query.
Connect the PivotTables through a shared Data Model dimension
Use a unique Nomenclature dimension to relate all three source tables and control their reports with one slicer.
PivotTables based on separate source tables cannot ordinarily share a slicer through Report Connections. Building all three reports from the same Data Model gives the slicer a shared dimension to filter.
The dimension's Nomenclature column must contain unique, nonblank values, and its values and data type must match the corresponding columns in the source tables.
Select a cell in each Excel table and choose Data > From Table/Range. In Power Query, select Home > Close & Load > Close & Load To, then choose Only Create Connection and select Add this data to the Data Model.
In Data > Queries & Connections, right-click each source query and choose Reference. In each referenced query, keep only the Nomenclature column. Use Home > Append Queries > Append Queries as New to combine the three referenced queries.
In the appended query, remove blank or null Nomenclature values, select the Nomenclature column, and choose Home > Remove Rows > Remove Duplicates. Choose Close & Load To, then load the query as a connection and add it to the Data Model.
Open Power Pivot > Manage and switch to Diagram View. Create a relationship from the unique Nomenclature column in the dimension table to the Nomenclature column in each of the three source tables.
Choose Insert > PivotTable and select Use this workbook's Data Model. Build each PivotTable using fields from its corresponding source table, and create its PivotChart with Insert > PivotChart. Rebuild existing reports if they were created from separate sources rather than the shared Data Model.
Select a Data Model PivotTable, choose PivotTable Analyze > Insert Slicer, and select Nomenclature from the dimension table. Select the slicer, open Slicer > Report Connections, and check all three PivotTables.

Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel files, making it easy to move everyday workbook tasks between suites. The shared Data Model slicer setup described above is an Excel-specific solution.

Frequently Asked Questions
Why don't all three PivotTables appear in Report Connections?
PivotTables created from separate sources may not share a compatible cache or Data Model. Build the reports from the same workbook Data Model, then select the slicer and open Slicer > Report Connections.
Why does the Nomenclature dimension need unique values?
The dimension acts as the one side of each relationship. Remove duplicates and blank or null values in Power Query before adding it to the Data Model.
Will the slicer also filter the PivotCharts?
Yes. A PivotChart follows the filters applied to its associated PivotTable. Connect each PivotTable through the slicer's Report Connections.
How do I include new Nomenclature values in the slicer?
Add the values to the source Excel tables, then choose Data > Refresh All. The appended dimension query and connected reports can then update with the new values.




