Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Multiple slicer accessing one table - make one slicer one-directional

I have multiple slicers on a single table.

 

Each slicer filtes on a single column.

 

I want that the selection on slicer "column 1" has no effect on slicer "column 2" or "column3". This means that slicer "column2" should be filtered based on the selection in slicer "column3" and vice versa. But selection of slicer "column1" should have no effect on slicer "column2/3".

Need Help
Show and Tell
  • visheshjain's avatar
    visheshjain
    3 years ago

    Hi Anonymous,

     

    Select the slicer and from the Formatting tab in the ribbon, use 'Edit Interactions' to block each slicer from filtering the other.

     

    Hope this helps.

     

    Thank you,

    Vishesh Jain

2 Replies

  • visheshjain's avatar
    visheshjain
    Icon for Impactful Individual rankImpactful Individual
    3 years ago

    Hi Anonymous,

     

    Select the slicer and from the Formatting tab in the ribbon, use 'Edit Interactions' to block each slicer from filtering the other.

     

    Hope this helps.

     

    Thank you,

    Vishesh Jain

  • Arul's avatar
    Arul
    Icon for Super User rankSuper User
    3 years ago

    Anonymous ,

    Select column 1 slicer and go to Format tab and then click Edit interactions now you would get the two icons (filter and none) at the top of column 2 and column 3 slicer. Click the none icon for both column 2 and column 3 slicer the filtering goes off for two slicers. (attached the sample image for reference)

    Thanks,

    Arul