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 Slicer on Table and PivotTable (works with > 1 slicer)If you have issue putting this in place please let me know and share (i.e. with OneDrive, Google Drive or the like) a representative workbook - Thanks
