How to reverse the filter Value in same page of Power BI

[kalif]

Dear All Find the below Power BI table & visual page 1. Date Table 2. Table 1 3. Table 2 4. Table 3 Visual

[Anonymous · Accepted solution]

HI @kalif,

Actually, current power bi not support direct get reverse filter value. You can try to write a measure as value level filter to filter records.

Sample measure:

Tag Measure =
VAR curr =
    SELECTEDVALUE ( Table[Column] )
RETURN
    IF (
        curr IN EXCEPT ( ALL ( Table[Column] ), ALLSELECTED ( Table[Column] ) ),
        "Y",
        "N"
    )

Then drag it to visual level filter(filter 'N' records) of visuals which need to show reverse filter result.

Regards,

Xiaoxin Sheng