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 word...
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.