Forum Discussion
Advanced filter
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
1 Reply
0 & 1That'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.
