Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Flittering two columns with one slicer

I have a table with a list of clash test matrix test results therefore in the table we have for example:

 

clash ID combined disciplineleft disciplineright discipline# of clashes
001_clash AR VS ARARAR100
002_clash AR VS DRARDR25
...............
052_clash ST VS DRSTDR0
...............



we have 9 disciplines in total
AR , ID, ST, ME, WS, DR, FF, EL, LA
so the rest of our table will be a combination of any two and each discipline can be either on the right or left.

 

Currently, I have two slicers to filter the left group, and the second to filter the right group.

kha_powerbi_0-1676376600281.png

However, I want the slicer to work regardless of whether its on the right or left.

For example:
slicer 1= DR slicer 2= AR
The output of Left & Right slicers: (empty since clash has AR left and DR Right opposite to the current filter)

clash ID combined disciplineleft disciplineright discipline# of clashes
     


Desired output in the table

clash ID combined disciplineleft disciplineright discipline# of clashes
002_clash AR VS DRARDR25

 

2 REPLIES 2
miTutorials
Super User
Super User
Anonymous
Not applicable

yes this works for one slicer but if I add another slicer it wont work to filter out the rows with the same discipline ( eg: AR|AR) but insted it will give all values with AR in them. this does work however for different disciples with two slicers (eg: AR|DR). Is there a way to make it filter out the same discipline group?

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.