Filtering on Multi-Values/Tags

[adx14]

I have a table of tags for products that I am using to categorize the products. A product might have a bunch of tags. I'm plotting the quantities of the products in a treemap by tag. The problem I have is that when you filter on one tag with a slicer, the treemap no longer shows all the other tags that products with that tag have.

The example below matches the data structure I have. In the example, I have Animals with quantities, and tags for the animals. If I filter on the Mammal tag, I want to see the breakdown of Vegetarian, HasTrunk, etc. in the treemap Instead, I just get Mammal=52 (Elephants + Horses + Rabbits). 

I think I need to recast the data to have all the possible combinations of tags and filter on that combination set, but I am not sure the best way to go about doing this. 

Animals

ID	Name	Quantity
1	Elephant	30
2	Horse	2
3	Fish	10
4	Rabbit	20

Tags

Tag

Mammal

Reptile

Gray

Green

Vegetarian

FourLegs

Gills

HasTrunk

AnimalTags

AnimalId	Tag
1	Mammal
1	Gray
1	HasTrunk
1	FourLegs
2	Mammal
2	Vegetarian
2	FourLegs
3	Gills
4	FourLegs
4	Mammal
4	Vegetarian

I have a relationship 1-Many Animals[Id] - AnimalTags[AnimalId] and 1-Many Tags[Tag] - AnimalTags[Tag].

Thank You! 

[amitchandak]

@adx14 , change the join of Animals to AnimalTags as Many to Many and filter direction from AnimalTags to Animal and try

[adx14]

Hi-

Thanks for this! I gave it a try but it doesn't seem to be doing what I want. Here's the sample file with the data: https://1drv.ms/u/s!As_KtLaSMEMCit0FDcgZToDjg_sa2g?e=9u9xaf

What I'm hoping for is if you pick Mammal in the slicer, you should still see the breakdown in the Tree Map of the other tags where they are associated with a mammal.

Thanks!