Forum Discussion
Connecting slicers to different tables/charts
I have three tables of data. Each has a pivot table and pivot chart. In each chart the data is displayed from the field Nomenclature. I can’t figure out how to have one slicer with the Nomenclatures ...
You need to first add your three tables to the Data Model. After which you need to create a fourth table which comprise a single column containing a unique list of all entries from the Nomenclature columns in the three data tables (this can be done dynamically if desired, for example within Power Query).
Within Power Pivot, you then create relationships between this new table and each of the three data tables. A slicer based on the fourth table will then filter data from the other three tables.
Regards