Include Exclude option in Power BI matrix visual

[Anonymous]

Hi Is ther any way to hide the option for Include/exclude option on matrix visual whe we do a right click on row?

[WendyDUFE]

@Anonymous  Hi Shilpi, 

Have you tried the solution? does it work ? 

Thank you

[v-shex-msft · Accepted solution]

Hi @Anonymous,

You can create a measure with unrelated table fields filters and extract selected values to compare with current row contents to return tag.  After these steps, you can use this measure on 'visual level filter' as a filter to achieve include or exclude effect filter effect.

Applying a measure filter in Power BI 

Calculate Table:

Selector=Values(Table[Column])

Measures:

measure filter (Include) =
VAR selected =
    ALLSELECTED ( Selector[Column] )
RETURN
    IF ( SELECTEDVALUE ( Table[Column] ) IN selected, "Y", "N" )

measure filter (Exclude) =
VAR selected =
    ALLSELECTED ( Selector[Column] )
RETURN
    IF ( SELECTEDVALUE ( Table[Column] ) IN selected, "N", "Y" )

Notice: if you do not want to add an additional table as the source of measure filter, you can consider defining variables into the measure and compare that variable with current row contents.

Static measure filter (Include) =
VAR selected = {"A","B","C","D"}
RETURN
    IF ( SELECTEDVALUE ( Table[Column] ) IN selected, "Y", "N" )

Static measure filter (Exclude) =
VAR selected = {"A","B","C","D"}
RETURN
    IF ( SELECTEDVALUE ( Table[Column] ) IN selected, "N", "Y" )

Regards,

Xiaoxin Sheng

[amitchandak]

It seems like the default option.  What is the need?

[WendyDUFE]

@amitchandak  HI Amitchandak, 

I have the same needs as well. For my case, when publishing the pbix file, I set the filter pane as hide. So when user browse the report from web side, after they select include or exclude, they can not cancel it, which brought a lot of confusion. 

This is a cool feature, but it is prefered to be optional, not default.  

Any idea ?