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