Forum Discussion
Power Bi Hierarchy Reporting
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.
Hi Please find an example of hierarchy
value Node Product 169 Node ProductGroup1 103 Node Car 33 Node Audi 33 A1 10 Data A2 11 Data A6 12 Data Node Boat 70 Boatv1 30 Data Boatv2 40 Data Node ProductGroup2 66 Node Mobile 66 Node Iphone 46 Iphone4 10 Data Iphone5 11 Data iphone6 12 Data iphone7 13 Data samsungs8 20 Data For example, I have one table
- Product and Value
I want to have the hierarchy where describe this way!
Cheers
phenohana123,
Create Parent-Child hierarchies following the instrunctions in the blog below, then create visual in Power BI Desktop.
http://www.daxpatterns.com/parent-child-hierarchies/
Regards,