Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear All,
I can slice a table for the following row values:
0
1
2
3
What I want to achieve is a slicer where I can filter for the following options:
0 & 1,
0 & 2,
0 & 3.
In other words, you can slice for 1, 2 & 3 only but when you do you always slice for 0 as well.
Thank you very much
gianmarco
0 & 1
That's not what you mean, you need 0 || 1 (or, not and).
Usually this is achieved by UNIONing two tables, one static (with the 0) and one to feed the slicer (1,2,3). The UNION needs to be done inside a measure and that measure needs to produce a 1/0 value that can be used as a visual filter.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.