Hierarchy chart

[Kappa]

Hi how to create a hierarchy chart using the custom visual Hierarchy Chart by Akvelon?

The chart to be represented :

Canada > Sectors > Subsectors > Industry Groups > Industries > Canadian Industries. Considering GDP as the values.

The .pbix file can be found in the link attached.

https://we.tl/t-VoPqEoldKv

Thanks 

[Tutu_in_YYC]

Hi Kappa,

You may not be able to visualize what you want in the Heirarchy Chart by Akvelon. The chart requires a specific single table structure and uses Parent-Child hierarchy.

Here is a reference
https://powerbidocs.com/2020/10/27/hierarchy-chart-by-akvelon-custom-visual-in-power-bi/

[Kappa]

Thanks for the reply @Tutu_in_YYC . How could we create the mentioned hierarchy and aggregate the GDP values. For the reference, the image has been attached. 

Image

This is the idea and the attached is the demo image.

The retail section consists dealers, wholesale and luxury items and so on.

Eg:- After dividing, when we select two components the result shows the aggregation of the GDP.

1. Canada : $50,00,000

 Retail + Manufacturing + Finance =  $100,000

Furthermore, selection items gives the aggregation of GDP.

[Tutu_in_YYC]

Try using Decomposition Tree. It is available in all Power BI Desktop.

[Kappa]

Yes, already tried that but wanted to have the akvelon visual type instead of the standard default chart. Also, The treeviz satisfies the visual but the look and feel is not that good

[Tutu_in_YYC]

I agree. The akvelon style is better, but i was not able to find any visual that does that with a star schema. Lets see if the community has other ideas.