Power BI

Ultimate Decomposition Tree: An Infographic Breakdown

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.
Figure i: Clicking on Get more Visuals
Figure i: Clicking on Get more Visuals
  • Now, click on Infographics from the Filter by dropdown.
Figure ii: Clicking on infographics to filter out search results from other custom visuals
Figure ii: Clicking on infographics to filter out search results from other custom visuals

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.
Figure iii: Ultimate Decomposition Tree Infographic
Figure iii: Ultimate Decomposition Tree Infographic
  • Click on Add.
Figure iv : Adding the Decomposition Tree Infographic to Visualization Pane
Figure iv : Adding the Decomposition Tree Infographic to Visualization Pane

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.
Figure v : Ultimate Decomposition Tree in action
Figure v : Ultimate Decomposition Tree in action

It will be converted to a minus sign, and a new hierarchical level appears.

Figure vi: Decomposition Tree showing data hierarchically
Figure vi: Decomposition Tree showing data hierarchically

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:

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. 

Leave a Reply

Your email address will not be published. Required fields are marked *