Forum Discussion

Thamer_Tarabzouni's avatar
Thamer_Tarabzouni
Copper Contributor
Oct 06, 2022

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...
Excel
Lorenzo's avatar
Lorenzo
Silver Contributor
What I previously pictured does it
tomasnavarro's avatar
tomasnavarro
Copper Contributor
Dec 06, 2023
Hi, and how can you do this? i am having the same problem.
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Dec 06, 2023

    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

Resources