Exploring the Decomposition Tree Visual in Power BI

Struggling to get business users in sync about how to consistently slice and dice a metric in a report? Try out the Decomposition Tree visual in Power BI's desktop version and let the end users decide for themselves.

During the requirements gathering phase of a report, try to understand how business users typically want to analyze a particular metric or individual categories. Often times it’s something straightforward like Sales as it pertains to various levels of their organizational hierarchy. In which case, you can simply make a bar chart with the ability for data consumers to drill up and down various levels of a hierarchy.

But this can be limiting as the hierarchy has to be determined in advance by the report creator. Say that a company wants to analyze their retail sales data by various item attributes, in various orders. That’s where a Decomposition Tree is ideal – it allows the end user to fully customize which order they view these attributes.

Let's stick with the retail sales example and illustrate a couple scenarios to examine the point further.

Scenario 1

A department President for the “core” business wants to see how sales break down by Collection, then Price Point, then Style. That President has the ability to start with a blank slate and create the type of visualization seen below. Then they can start exploring the various Collections to analyze which Price Points and Styles are driving sales.

Decomposition Tree visual #1

Scenario 2

A manager for the Spring Collection wants to see how sales shake out between business units, first and foremost. Then after understanding that distribution, is interested in the Style breakdown for a given business unit.

Decomposition Tree visual #2

The best part about the Decomposition Tree is that it can allow for both of these scenarios in one visual. On top of that, it’s very easy to setup in Power BI Desktop. You simply feed it a metric to analyze and drop in all attributes that a user would possibly want to see. Once published, the user has the ability to add or subtract any layers of analysis to fit their needs.

How do I incorporate the Decomposition Tree visual option into my PBI reports?

The Decomposition Tree is a unique visual because it isn’t automatically part of Power BI Desktop’s out-of-the-box visualization options. It was rolled out as part of the November 2019 release as a “preview” feature. However, current versions now have the Decomp Tree as a default option, but in case you're working with an older PBI version here are the steps to take to enable this feature.

To enable this additional option, it requires going to File -> Options and Settings -> Options -> Preview features -> check Decomposition Tree Visual. It will require a restart of Power BI Desktop, but then the Decomposition Tree option will appear in your list of visualizations:

Decomposition Tree option in Power BI

Written by Eric Leuthold

Manager of Analytics at Data Ideology

Eric Leuthold is a Manager with over 8 years of experience in data analysis and business intelligence.

Deploying Power BI without the appropriate planning and preparation sets the organization up for several challenges down the road.  When deployed properly the organization can modernize the way it operates. 

POWER BI - CHECKLIST

Before you start, you’ll want to make sure you’ve thought of everything. 

 

Implementing Power BI can be quite the undertaking.  Use this Power BI checklist as a reference to make sure you’re prepared for every aspect of your project. 

  • Deploy Power BI with the appropriate planning.
  • Accelerate Power BI adoption.
  • Enable the organization.
DEI

Mothers in Tech: Design your Own Work-Life Balance

The sad reality for Mothers in Tech is that 72% feel their careers still suffer due to childcare & family responsibilities.
Healthcare

Interoperability in Healthcare: A Patient-First Framework

Healthcare Interoperability is a framework where systems are coordinated to provide standardized methods of interacting with patient data.
Healthcare

Pitfalls to Avoid when implementing Health Information Exchange

In recent years, Health Information Exchange (HIE) capabilities have helped mobilize patient data allowing clinicians and healthcare managers to provide near real time diagnosis closing the gap on member care.