Forum Discussion

Resolver I

7 years ago

Solved

Display state wise sales - exclude slicer selection

Hi everyone, I have one table. I want to display "sales", based on Slicer selection. I have taken "State" into slicer. When choose state in slicer, show all state wise sales, except slic...

Need Help

Anonymous
7 years ago
Hi venug20,

Normal slicer not support exclude filter affect, you need to do some custom steps with a measure as filter to achieve this effect.
Please take a look at attachment files if it works on your side.

Regards,
Xiaoxin Sheng
exclude slicer.pbix3.9 MB

Anonymous

Not applicable

7 years ago

Hi venug20,

Selector table is used to be the source of slicer, that you can use 'allselected' function to get selected items from slicer.

Selectedvalue function is used to get current row content, then you can compare selected items and current row content to return tag Y if current row are in selected items.

Drag this measure to visual level filter and keep 'N' tag records which means not include in selected items.

Notice: please not create relationship from selected table to original table, it will keep slicer operation only works on measure and not filter on original table.

Reference links:

SELECTEDVALUE Function

ALLSELECTED Function (DAX)

Regards,

Xiaoxin Sheng