Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

filter for slicer

Hey, I would like to apply a filter for a slicer field in the following way: In table 1 I have an "id" column and a  boolean column "a". If a =True, the corresponding id should appear in the slicer...
Need Help
  • DS12345's avatar
    DS12345
    6 years ago

    Hi Susanne,

     

    A measure could be the solution. Measure = IF(a=true, 1, 0)

    Then add this measure as a filter to the slicer and select measure = 1

     

    Hope this solves your problem.

     

     

DS12345's avatar
DS12345
Frequent Visitor
6 years ago

Hi Susanne,

 

A measure could be the solution. Measure = IF(a=true, 1, 0)

Then add this measure as a filter to the slicer and select measure = 1

 

Hope this solves your problem.