Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Exclude Slicer Selection

Hi, In my report there are 3 slicers-let it be Slicer1,Slicer2,Slicer3. If I select values those should be excluded from the Visual/Report(All the values from three slicers). Thanks in Advance. a...
Tips and Tricks
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    Ok, I have managed to test this.

    Create a measure for to exclude each slicer selection. In this example:

    Exclude Channel =
IF (
    ISFILTERED ( 'Exc Channel'[Channel] ),
    COUNTROWS (
        EXCEPT ( VALUES ( FactTable[Channel] ), VALUES ( 'Exc Channel'[Channel] ) )
    ),
    1
)

    Exclude Item =
IF (
    ISFILTERED ( 'Exc Item'[Item] ),
    COUNTROWS ( EXCEPT ( VALUES ( FactTable[Item] ), VALUES ( 'Exc Item'[Item] ) ) ),
    1
)

    Exclude REF =
IF (
    ISFILTERED ( 'Exc REF'[REF] ),
    COUNTROWS ( EXCEPT ( VALUES ( FactTable[REF] ), VALUES ( 'Exc REF'[REF] ) ) ),
    1
)

    Add these measures to the filters for the visual in the filter pane and set the value to greater or equal to 1:

    to get:

     

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , to exclude, it is better to have an independent slicer, I discussed here

 

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks @amitchandak - I am using Independent slicers only. It is fine with one slicer but when I am trying with 2 or 3 slicers it's not working