Use One Slicer to Filter Multiple Excel Charts
Question details
Connect one slicer to multiple Excel dashboard charts based on three separate tables.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A dashboard uses three source tables, and the user wants one slicer to filter all related charts.
- Observed behavior
- A slicer filters only the tables or PivotTables to which it is connected; separate sources do not automatically share its filter.
Check that the tables have a common field, such as a category or nomenclature key, and that matching values are consistent across them. If using the Data Model, confirm that your Excel version supports Data Model relationships and PivotTable Report Connections.
Connect PivotCharts through the Excel Data Model
Use a shared dimension table to filter PivotCharts built from separate but related source tables.
The shared dimension table needs one unique row for each slicer value. Each source table should contain a matching key, and the PivotTables must use the same Data Model.
Select each source table and use Power Pivot > Add to Data Model, or load each query to the Data Model through Data > Get Data.
Create a table with one row per nomenclature or category key, then add it to the Data Model. Include the field you want to display in the slicer.
Open Data > Relationships > New and relate the key in each source table to the unique key in the shared dimension table.
Insert PivotTables using the workbook Data Model, and use PivotTable Analyze > PivotChart to create the dashboard charts.
Select a model-based PivotTable, choose PivotTable Analyze > Insert Slicer, and select the shared dimension field. Select the slicer, open Slicer > Report Connections, and check each PivotTable that should respond.

Combine the source tables before creating PivotCharts
Use one normalized table when the three sources can be combined into a consistent structure.
Explore spreadsheet dashboards in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheets for an easier transition, while using Excel for the Data Model and slicer connections described above.

Frequently Asked Questions
Why does my slicer control only one chart?
A slicer filters only connected tables or PivotTables. Select the slicer and open Slicer > Report Connections to connect other compatible PivotTables behind the charts.
Why isn't a PivotTable listed in Report Connections?
The PivotTable may use a different source or PivotTable cache. Recreate it from the same Data Model, or copy an existing PivotTable based on the combined source, then check Report Connections again.
Can one slicer filter charts based on three separate tables?
Yes, if the tables are related to a shared dimension in the Data Model and the charts are built from model-based PivotTables. Insert the slicer using a field from that dimension, then connect the PivotTables through Report Connections.
Can I connect the slicer directly to ordinary charts?
Report Connections connects a slicer to compatible PivotTables, not directly to ordinary charts. Use PivotCharts based on the connected PivotTables for the approach described here.




