I am running Excel 2016 and have multiple tables (NOT Pivot Tables) in my spreadsheet that all have a Date column and charts built off of the various tables.
I have created a slicer for one of the tables and it controls both the data table and the charts built off of that table.
Is there any way to apply that same slicer to the other tables (and therefore, the charts build off of those tables).
I am NOT talking about Pivot Tables - there are lots of examples out there on how to use a single slicer on multiple Pivot Tables. I cannot find anything on using 1 slicer for multiple NON-Pivot Tables.
Any help would be appreciated.
Hi,
A slicer can be connected to multiple Pivot tables reports only if they have the same pivot cache. I the data source for some pivots is different, those pivot tables cannot be controlled with the same slicers.
For table slicers, it's a completely different situation: there is no cache because there is no data source.
Usually, a different table will have different headers, but even if they have 1 or all identical headers there is no way to force a table slicer to filter other table data.
The only way is to merge those 2 table with Power Query, this way you will have a single table, with all the fields from both tables. Or load the tables to the data model, add a relationship between the 2 tables, then create a power pivot report with fields from both tables.
Thank you, Catalin. I will consider your alternatives.
Did power query work ??
