Forum Discussion
Power Bi Hierarchy Reporting
can you use the matrix preview visualisaton?
This is the link you sent to me!
But here, you are adding more fields. I just want to have only one hierarchy for Region. Not Region, Country, City in separate. I want to have Region, Country, City in same so I can maintain in one.
This is an example, because I have also Product Hierarchy with 6 level maximum and the last level can be any level!
phenohana123 i dont understand if you combine region, country etc into 1 hiearchy they will work as one?
Ok. Let me explain better.
I only have data from lowest level, in this case countrys, another nodes are whole virtuals.
for example, I have data from Switzerland and Others not for Central Europe.
Central Europe is just a "dummy node" where calculate it automatically.
got it?
phenohana123 was that explaning better :smileyvery-happy:
you saying you have a mix of things in your column and you want to create a hierarchy with levels but you only currently have one column?
since power bi is a data visualiastion tool, visuals are usually best to explain things.
ideally...
show me what you have in the table
and then show me what you want.
