Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.