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
Thamer_Tarabzouni's avatar
Thamer_Tarabzouni
Copper Contributor
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.
Lorenzo's avatar
Lorenzo
Silver Contributor
Oct 19, 2022
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