Forum Discussion
Power Bi Hierarchy Reporting
Dear All, I would like to know if there is any Power BI Visual Extension so I can work with Hierarchy like Region - SALES Europe - 1.000.000 - Scandinavia - 500.000 --Finland 200.000 --Sw...
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,