Forum Discussion
Create a dynamic tree chart based on different measures
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!
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
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.
3 Replies
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
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.
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.
I used the deneb chart to create this kind of chart.
