Pivot Table Issues

Use One Excel Slicer to Filter PivotTables from Multiple Tables

Natalie TaylorNatalie Taylor Nov 18, 2026 870 views

Question details

The user needs one slicer to filter three PivotTables and their PivotCharts using all unique Nomenclature values from three Excel tables.

Use One Excel Slicer to Filter PivotTables from Multiple 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.
Before you start

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.

Solution 1Recommended

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.

1
Load 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.

2
Create the dimension query

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.

3
Keep unique values

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.

4
Create relationships

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.

5
Build the reports from the model

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.

6
Insert and connect the slicer

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.

Connect the PivotTables through a shared Data Model dimension
Refresh after source changes: Use Data > Refresh All after adding or changing source values so the dimension list and PivotTables update. The connected PivotCharts follow their PivotTables' filters.
Free Microsoft Office alternative

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.

Open and edit Excel XLSX and XLS filesWork with spreadsheet tables and PivotTables in a familiar interfaceUse a free, lightweight office suite for everyday documentsMove existing Office files into WPS without starting from scratch
microsoft office alternative - wps office

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.