Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.