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
Power BI DataViz World Championships

Power BI Dataviz World Championships

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

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.