Forum Discussion

SritejaGolla's avatar
SritejaGolla
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago
Solved

Two slicers (from same column) and one visual show excluded values.

Hello Everyone, I have the below request and i was able to find the solution when i was using only one slicer from the below article (https://youtu.be/1SnELZGveYs?si=hCBTqIDxEq8UEwDk)  and could no...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi SritejaGolla 

     

    Please try this:

    Here I create a measure:

     

    MEASURE =
    VAR _Slicer2 =
        SELECTEDVALUE ( SeperateTable[Industry] )
    VAR _Vtable =
        SELECTCOLUMNS (
            FILTER ( ALL ( 'TestTable' ), 'TestTable'[Industry] = _Slicer2 ),
            "_Country", [Country]
        )
    RETURN
        IF (
            SELECTEDVALUE ( TestTable[Country] ) IN _Vtable,
            BLANK (),
            SELECTEDVALUE ( TestTable[Industry] )
        )
    

     

    Then add it to the table visual.

    the result is as follow:

     

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.