Hierarchy chart

Question

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.

Thanks

tutu_in_yyc · Answer

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

tutu_in_yyc · Answer

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 referencehttps://powerbidocs.com/2020/10/27/hierarchy-chart-by-akvelon-custom-visual-in-power-bi/

kappa · Answer

Thanks for the reply&nbsp;Tutu_in_YYC&nbsp;. How could we create the mentioned hierarchy and aggregate the GDP values. For the reference, the image has been attached.&nbsp;&nbsp;ImageThis is the idea and the attached is the demo image.The retail section consists dealers, wholesale and luxury items and so on.&nbsp;Eg:- After dividing, when we select two components the result shows the aggregation of the GDP.1. Canada : $50,00,000&nbsp;Retail + Manufacturing + Finance =&nbsp; $100,000&nbsp;Furthermore, selection items gives the aggregation of GDP.&nbsp;&nbsp;

tutu_in_yyc · Answer

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

kappa · Answer

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

Forum Discussion

Hierarchy chart

5 Replies

Related content

Date hierarchy

Multi level hierarchy in Gantt chart by microsoft corporation

Date Hierarchy

Portfolio hierarchy chart - HELP!

Ragged Hierarchy?