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

[Anonymous]

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".

[Arul]

@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

[visheshjain · Accepted solution]

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