Treemap and grouping by multiple tags

[Anonymous]

Hello there 😉

I'm a little bit stuck and could need some help.

I have list of 500 products within about 20 different categories. I want to visualize the count of the products grouped by the category in a treemap. Some of the products have more than one category.

Product          Category

Product 1       Cat 1

Product 2       Cat 2

Product 3       Cat 3

Product 4       Cat 1, Cat 3

Product 5       Cat 1, Cat 2, Cat 3

....                    .....

It doesnt make sence to have an own category/grouping for Product 4 in the treemap visual. My goal is, to have product 4 shown both in Category 1 and 3

My idea was splitting the Category column by ",".  This results in 3 columns for category and this doesnt work to use more than one column for grouping in the treemap visual.

Has anyone an idea to help me?

Thank you 😉

[amitchandak]

@Anonymous , I think is better to split that into rows in power query

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

[Anonymous · Accepted solution]

Thanks for your help;)

I solved it this way: Solved: Grouped Count Across Multiple Columns - Microsoft Power BI Community