Forum Discussion
Representing hierarchical nested categories
Uzi2019 thanks for your fast reply.
While this will show the first level of hierarchy, it seems to me, it does not let me "drill down" through the levels as I'd hoped for.
In your screenshot "Meat" is listed in the same level as "Beef". I'm looking for some representation where "Beef" - together with its children "Ham" and "Steak" - is listed only as child of "Meat".
Similar to the folder tree where a folder can have folders and subfolders.
Or am I simply missing a setting in the visual?
Community ChampionHi Sandybanks
It means you have three hierarchy levels.
you have properly mapped it against meat>beef>> ham, steak
You have to categoriz it properly. I have modified your data like added new column as sub category.
You have to follow the same rule if you want proper sub Hierarchy.
I hope I answered your question!
Uzi2019 that's exactly my problem.
My example date with apples and meat, of course, is just sample data. My real life data is much longer and I have categories which are nested multiple times. So, categories with sub-categories and sub-categories and so on.
The problem I have is, that I can't simply "restructure" my data. However, I'd like to visualize this parent-child logic in a way that I can see it as tree or something similar.
And I wonder if I can do this in PowerBI.