Checkbox filter with multiple categories

Need help Database
1

CONTEXT
I have a category column by which I want to filter using check boxes like in Amazon.
When the checkbox is ticked - RG should show all items that have one of the categories chosen.
example. category (sweet, bitter, spicy)

PROBLEM
Filtering per one category (sweet) - no problem
But some items have multiple categories (sweet+spicy OR bitter+sweet). So I don’t know how to include them correctly.
I tried lots of methods but can’t find “is in” argument to make it work

GOAL
How can I filter all of this using check boxes

2

You can probably do it natively but might be easier to just use this Facet / Search Filter Widget Plugin | Bubble as it sounds like it does exactly what you are after.

3

Thanks I have figured how to do it natively!