Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Multiple Columns Slicer (Not hierarchy

Hi all,

 

I have a lot of columns with 1/0 value. Is it possible to create a slicer where I can tick off / filter the columns?

 

Example:

 

 

Is it possible to just make a slicer with all the Categories, where I can tick multiple off? (Filter by 1 when selected)?

 

Like check boxes etc.

Need Help

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    4 years ago

    Hi Anonymous ,

     

    If you unpivot the columns then you get a model with 4 columns:

    • ComplaintID
    • CustomerID
    • Attribute
    • Value

    Then you could easaly make the filter you need.