Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Slice data in Power BI based on multiple columns

Ideally, I want to use just one slicer, instead of two. Source and Target should be sliced using one slicer. 

For example as in the above image if you select NWPS-ERMS and Tyler Corrections, the table should pull all relations between NWPS-ERMS --> Tyler Corrections and Tyler Corrections -->  NWPS-ERMS. 

Let me know if there is way to just have one slicer doing the above functionality instead of using two. 

Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    At first, you need to create a distinct table as slicer. Then refer to the following measure:

    Measure =
VAR a =
    ALLSELECTED ( 'Slicer'[Column1] )
RETURN
    IF (
        SELECTEDVALUE ( 'Table'[Source] ) IN a
            && SELECTEDVALUE ( 'Table'[Target] ) IN a,
        1,
        0
    )

    Set the rule in filter pane to show result whose measure is 1.

    Here is my test file for your reference.

     

2 Replies