Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to model "Filters for multiple values"

Hi,

 

I know how to do Single-Values-Filters: A OR B OR C...

 

Model:

 

Visual:

 

But I do not know how to model Multi-Values-Filters, like A AND (maybe? Checkbox) B AND (maybe? Checkbox) C

 

Visual:

(I do not mean how to allow for Checkboxes and multipleSelection of them under "Formatting"...)

 

 

....but how to model the data.

 

Do I unpivot them? Do I group them? I´m stuck...

 

I know that "narrow & long"...

 

Is better than "broad & short"...

 

 

However, for Single-Value-Filters "broad & short" I can easier understand...

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    If you select A, B, C in the slicer, data containing A, B, and C will appear at the same time. This is the logic of AND.
    If you select A, B, C in the slicer, and you want to appear data containing A, or containing B, or containing C, this is the logic of OR.

    If you want to implement the logic, just hold down Ctrl and make multiple selections. If you want to implement OR logic, check out this similar post.

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    If you select A, B, C in the slicer, data containing A, B, and C will appear at the same time. This is the logic of AND.
    If you select A, B, C in the slicer, and you want to appear data containing A, or containing B, or containing C, this is the logic of OR.

    If you want to implement the logic, just hold down Ctrl and make multiple selections. If you want to implement OR logic, check out this similar post.

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      As I mentioned: I do not mean how to allow for Checkboxes and multipleSelection of them under "Formatting"...

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    4 years ago

    Thank you! I have posted meanwhile - but that could be the solution!