Forum Discussion

catiabd's avatar
catiabd
Copper Contributor
Feb 04, 2019

Slicers Connect

Hello,

I need your help with slicers. Is there anyway of connecting the pivot slicers with the source table. Ideally I would sort the Pivot and the table at the same time.

 

Thank you very much !

  • Hi,

     

    You may slicer your source table and that filter affects Pivot Table as well. Not in opposite direction.

    • catiabd's avatar
      catiabd
      Copper Contributor

      Hi Sergei, Tks, 

       

      I have tried to connect the table slicer with the pivots, but i cannot do it, how can I make that connection work and affect the pivots with the slicer created in the table source? Can you help me ?

      • You can't connect to both, you may filter source table and Pivot Table will work on filtered table

Resources