Forum Discussion
Categorize for treemap
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.
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.
1 Reply
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.