How to make a slicer to filter for multiple columns

Hi myou,

Based on my test, we can take the following steps to meet your requirement.

1. Create two calculated columns.

con = CONCATENATE(Table1[Member1],Table1[Member2])

con2 = CONCATENATE(Table1[Member2],Table1[Member1])

2. Create two measures as below.

Conca = CALCULATE(CONCATENATEX(VALUES(Table1[Member1]),Table1[Member1]),ALLSELECTED(Table1))

Measure = IF(MAX(Table1[con]) = [Conca] || MAX(Table1[con2])= [Conca],1,0)

3. Then we can create the visual and filter the visual based on the Measure.

For more details, please check the pbix as attached.

https://www.dropbox.com/s/6k18se3dh2ejjzu/How%20to%20make%20a%20slicer%20to%202.pbix?dl=0

Regards,

Frank

Hi myou,

Does that make sense? If so, kindly mark my answer as a solution to close the case please.

Regards,

Frank