Create a dynamic tree chart based on different measures

[rickferreiran]

Hello, I have a significant challenge ahead.

I need to create a tree chart based on measures that are grouped hierarchically. Specifically, I have 10 measures that are classified in this way. The table I am mentioning does not exist; I'm simply using it to explain the problem at hand. The KPIs are derived from different tables.

I would like to create a tree visual where each layer represents the average of the related measures at that level. For example, the overall average will include all KPIs, while A1 will be the average of KPI1, KPI2, and KPI3.

Do you know how to build this chart? Currently, the tree chart is not very useful because the nodes do not reflect the values from the dimensions, and I would like the ability to apply filters on the report that will dynamically change the chart.

Do you think I can use Python or HTML content to accomplish this?

Thank you for your help!

[rickferreiran]

I used the deneb chart to create this kind of chart. 

[v-veshwara-msft · Accepted solution]

Hi @rickferreiran ,

Thanks for posting your question in Microsoft Fabric Community.

Currently, Power BI doesn’t include a built-in visual that can display a hierarchical tree where each node shows calculated measure values across multiple levels. The Decomposition Tree visual can be used for hierarchical exploration, but it only allows drill-down into one path at a time.

If you need all nodes to be visible together, you can try a custom Tree visual from AppSource or build a parent-child table and use a Python or R visual to render the hierarchy. The Deneb visual is another option that lets you design custom layouts using Vega or Vega-Lite and supports interaction with report filters.

You can refer to similar discussions and documentation below:

Solved: Dynamic Hierarchy in Power BI Decomposition Tree B... - Microsoft Fabric Community

KPI Tree

Create Power BI visuals using Python in Power BI Desktop - Power BI | Microsoft Learn

Create and View Decomposition Tree Visuals in Power BI - Power BI | Microsoft Learn

Hope this helps. Please reach out for further assistance.

Thank you.

[v-kpoloju-msft]

Hi @rickferreiran,

Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.

Thank you.