Forum Discussion
How to link a slicer simultaneously to both a PivotTable and a normal table
Hi, I created a table from Power Query and I created several Slicers (Dept, ID, Date, Time). This to dynamically filter the list of rows displayed by the table. Also I created a pivot table to disp...
To clarify things, is this what you're trying to achieve?
where the 2 slicers (Customer & Product) are connected to and filter the Data and the Pivot?
Yes, this is what I need. A slicer that can be connected to both Data table, and Pivot table. So then I can use them interchangeably.
- What I previously pictured does it
- Hi, and how can you do this? i am having the same problem.
Hi tomasnavarro
Actually, as you probably experienced, this isn't possible as of today
A possible workaround is doc. in https://answers.microsoft.com/en-us/msoffice/forum/all/slicer-on-table-and-pivottable/c68c7691-5a81-4991-acf9-be4f2812620d (works with > 1 slicer)If you have issue putting this in place please let me know and share (i.e. https://support.microsoft.com/en-us/office/share-onedrive-files-and-folders-9fcc2f7d-de0c-4cec-93b0-a82024800c07, Google Drive or the like) a representative workbook - Thanks
