Ultimate Decomposition Tree: An Infographic Breakdown
Table of Contents
Introduction
The Ultimate Decomposition Tree, in Microsoft Power BI, is a strong Infographic visual tool for showing hierarchical information in a clear and organized way. Breaking down values at each node, it helps you look at the different layers in your data and see how different categories affect the final outcome. This infographic illustrates the way the decomposition tree makes complex datasets easier to work with by breaking them down into smaller pieces. Furthermore, this makes it easier to find key drivers, compare segments, and find useful information.
In this blog post, we will walk through a step-by-step tutorial on how this Custom Visual works in Power BI.
What are Infographics?
Infographics are a class of visuals that can embellish your reports and dashboards. Infographics are custom visuals in Power BI that are highly tailored to meet the specific needs of a report. Therefore, Infographics act like add-ons for the traditional visuals and provide an advanced level of customization and innovation.
Check out our Blog on Custom Visuals: Enhancing Reports with Custom Visuals in Power BI: What, Why, How and When?
How to add Infographics to your Power BI Report?
Infographics are a part of custom visuals in Power BI.
For this tutorial, you can refer to the exercise file provided at the end of this blogpost.
To Get Started:
- First, click on the three dots at the end of visualizations in the Visualizations Pane.
- Then, click on Get more visuals. A pop-up box appears.
- Now, click on Infographics from the Filter by dropdown.
Creating Ultimate Decomposition Tree
To Create Ultimate Decomposition Tree:
- Search by typing Ultimate Decomposition Tree in the Infographics Category of Custom visuals.
- Click on Ultimate Decomposition Tree.
- Click on Add.
A dialog box appears confirming the Import of Custom visual.
- Click OK.
- Click on Ultimate Decomposition Tree in the Custom Visuals section in the Visualizations Pane.
- First, drag and drop the column Product Line from the Products Table to the Category Data.
This is the first level of hierarchy in the data.
- Next, drag and drop the column Product Type from the Products Table to the Category Data.
The second level of hierarchy in the data.
- Then, drag and drop the column Product from the Products Table to the Category Data.
The third level of hierarchy in the data.
- Finally, drag the column Quantity Sold from the Sales Table to the Measure Data.
- Now click on Plus (+) sign to the right of Camping Equipment.
It will be converted to a minus sign, and a new hierarchical level appears.
Understanding the Output
Ultimate Decomposition Tree shows that the total quantity of all the products sold is 7M. These products consisted of three Product line categories. Next level down, the camping equipment consisted of three Product Types,
- Lanterns
- Tents
- Sleeping Bags.
875K Tents were sold, which consisted of 28.5% of the products sold in the camping equipment category. Furthermore, the number beside each box demonstrates the subcategories present at the node.
- For example, Lanterns consists of 12 products.
Additionally, the Ultimate Decomposition Tree can be formatted according to your requirements from the format options in the visualization pane.
Ultimate Decomposition Tree vs. Native Decomposition Tree
The Ultimate Decomposition Tree and the native Decomposition Tree differ greatly in terms of customization, design flexibility, and user experience, although both visuals accomplish the same goal of decomposing a measure into hierarchical levels. So, to help you understand when to use each, here is a side-by-side comparison.
Feature / Aspect | Ultimate Decomposition Tree (Custom Visual) | Native Power BI Decomposition Tree |
Availability | Custom visual must be imported from marketplace/AppSource. | Built-in standard visuals in Power BI. |
Hierarchical breakdown | Supports hierarchical breakdown, displaying levels of hierarchy for both measures and categories. | Allows for hierarchical breakdown: drill down in any order after dragging a metric into “Analyze” and dimensions into “Explain by.” |
Support for two measures & % calculation | Supports two measures and “% of node” / “% of total” calculations. | Uses a single measure for ‘Analyze’ and dimensions for ‘Explain by’. |
Customization / Visual enhancements | Enables customization in accordance with marketplace descriptions (colors, fonts, layout, labels, etc.). | Limited formatting compared to custom visuals; mostly functional/analytical. |
AI-driven splits / Root-cause | Not available. | Built-in AI-splits feature available (High/Low value options). |
Limitations | No public official limit found. | Up to 50 levels and 5,000 data points are supported; context-specific AI-split limitations may apply. |
When you want built-in features like AI-driven splits, root-cause analysis, simple drill-down, and stability under Power BI’s core functionality, use the native Decomposition Tree.
When you require additional flexibility, such as when comparing two measures, displaying percentage contributions, or altering the visual style beyond what native visuals permit, use Ultimate Decomposition Tree.
To learn more about Naïve Decomposition Tree in our Blog: Turning Data into Decisions: Using the Power BI Decomposition Tree for Root-Cause Analysis
Want to explore more custom visuals? Check out our blog: Top 4 Custom Visuals to Elevate Your Power BI Dashboards
Conclusion
Ultimate Decomposition Tree is a flexible and eye-catching tool that improves hierarchical data analysis. It shines when you need advanced customization, multiple measures, and clear infographic-style visuals, whereas the native Decomposition Tree excels at AI-driven insights and in-depth analytical exploration. You can select the best visual for your report, whether it’s for in-depth analysis or presentation-ready dashboards that convey insights quickly, by being aware of each one’s advantages.
FAQs
The Ultimate Decomposition Tree is a custom infographic tool in Power BI that makes it simpler to examine and comprehend complex datasets by breaking down hierarchical data.
The Ultimate Decomposition Tree is perfect for presentation-ready dashboards because, in contrast to the native visual, it emphasizes visual customization, supports two measures, and permits percentage-of-node computations.
Yes. Before it can be included in a report, the custom visual needs to be imported from the Power BI AppSource/Marketplace.
The Ultimate Decomposition Tree can be used to create aesthetically pleasing dashboards, compare various metrics, display percentage contributions, or deconstruct hierarchical data in an understandable, infographic-style manner.
Further Learning and Resources
To learn more about Power BI, check out our courses here:
- Power BI Essentials
- Power BI Report Design
- Power BI Advanced
- Power BI DAX Essentials
- Power BI Service Course
- ChatGPT Essentials
Want to learn how Microsoft 365 Copilot transforms everyday work with AI? Check out our Course:
Want to learn more about Power BI and how to make reports more efficiently?
Power BI training in Australia: We offer comprehensive training sessions across various cities, including :
Power BI Crash Course eBook: Download our detailed guide to take your Power BI expertise to the next level, covering topics from basics to advanced with practical examples and step-by-step instructions. (Limited time offer)
Download the Beginner’s Guide to Power BI
Ready to enhance your Power BI skills? Sign up for our training courses and explore our wide range of resources designed to elevate your data analytics capabilities.
Contact Us: Make an enquiry about our Power BI courses and find the proper training for you.







