How to model "Filters for multiple values"

[Anonymous]

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

[Anonymous · Accepted solution]

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.

[Syndicate_Admin · Accepted solution]

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

[Anonymous · Accepted solution]

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]

@Anonymous just add your column to the slicer and hold CTRl button for multi select for different values.

Regards,
John Basha Mattipati,
https://www.linkedin.com/in/john-basha-mattipati-06812980/

[Anonymous]

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