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...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • 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.

Anonymous's avatar
Anonymous
Not applicable
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.