Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have a table with a list of clash test matrix test results therefore in the table we have for example:
| clash ID | combined discipline | left discipline | right discipline | # of clashes |
| 001_clash | AR VS AR | AR | AR | 100 |
| 002_clash | AR VS DR | AR | DR | 25 |
| ... | ... | ... | ... | ... |
| 052_clash | ST VS DR | ST | DR | 0 |
| ... | ... | ... | ... | ... |
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.
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 discipline | left discipline | right discipline | # of clashes |
Desired output in the table
| clash ID | combined discipline | left discipline | right discipline | # of clashes |
| 002_clash | AR VS DR | AR | DR | 25 |
Check out this link below.
https://www.sqlbi.com/articles/creating-a-slicer-that-filters-multiple-columns-in-power-bi/
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?
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 57 | |
| 43 | |
| 41 | |
| 22 | |
| 17 |
| User | Count |
|---|---|
| 183 | |
| 114 | |
| 93 | |
| 62 | |
| 45 |