Single value in multiple groups on slicer

[sknudson]

Hello,

I am new to Power BI, but I am creating a resource library that essentially is a table of links and descriptions of the resource. I categorized the resources into multi-select options (for example: Resource A is referring to a resource that is both about Dogs and Cats, so each value Dog, and Cat, is chosen). 

When I go to my report and slicer, I want to be able to select "Dog" as a category, and have everything show up about dogs, including Resource A that is about dogs AND cats. 

I tried groupings but that doesn't seem to work because it appears that a value can only go into one group. Is that correct? If I put the "Dog and Cat" bucket under "Dog" group, then I can't also put it under the "Cat" group?

Any help is much appreciated. 

[amitchandak · Accepted solution]

@sknudson , Yes, If you want them in more than on group you need to create multiple groups or a table like this and join with you table M-M bi-directional join

Name	Group
cat	A
dog	A
cat	B
dog	B
rat	B