Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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?
User | Count |
---|---|
116 | |
73 | |
60 | |
48 | |
48 |
User | Count |
---|---|
171 | |
122 | |
60 | |
59 | |
56 |