Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Is there a way to get union of selection from 4 different slicers.
I have tried using the method os creating disconnected tables and creating a visual level filter to get union. It however doesnt work for more than 2 slicers.
Detailed method - https://apexinsights.net/blog/or-xor-slicing
Is there a way to scale up this method to accomodate 4 slicers? Or is there another method?
You can extend the author's method if instead of using the OR function you use || operator - that way you can chain together as many conditions as you like. Modifying the author's code would give you
OR Filter =
IF (
SELECTEDVALUE ( 'Data Table'[Letters] )
IN ALLSELECTED ( Letters[Letters] ) // Checks if current letter is in slicer selection
|| SELECTEDVALUE ( 'Data Table'[Numbers] ) IN ALLSELECTED ( Numbers[Numbers] ),
// As above for current number
1,
// Return 1 if value is selected in one or both of the slicers
0 // Else return 0
)
This is not working. If I choose any two slicers it doesnt work, there is no change in the visuals. If I choose yes on two slicers and no on the other two , it still doesnt work.
| User | Count |
|---|---|
| 52 | |
| 41 | |
| 32 | |
| 15 | |
| 13 |
| User | Count |
|---|---|
| 84 | |
| 72 | |
| 37 | |
| 27 | |
| 24 |