Categorize for treemap

[Rayvia]

Hey Guys,

i have a table with different categories(see Picture 1)

Categories of Member-Table:

picture 1

everytime a Entry fits a category the category gets marked.

I want to create a function that writes the name of the Attribute for every "x" in that column. To make a Treemap out of it.

Lets say this Table in Picture 1 has 31 Entrys everything i tried leads to a total amount of 31, but obviously since there can be more than one category for each Entry the total amount in this case should be close to 60.

[v-rzhou-msft · Accepted solution]

Hi @Rayvia 

Do you want to get the list of all entry out of the category in your table? I think you mark the entry out of the category by "X".

My Sample:

Select Name column and use Unpivot Other Columns in Power Query. Then we can get a list with all name with "X". Remove Value column.

Then we can use this new table to build a treemap out of it.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.