Slice data in Power BI based on multiple columns

[Anonymous]

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. 

[v-eachen-msft · Accepted solution]

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.

[amitchandak]

@Anonymous , refer if these can help

https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115