Power BI Decomposition Tree Breaking Down Your Data

Use the Decomposition Tree Visual in Power BI to explore your data and gain insights into how parts contribute to the whole.  Drill into hierarchies to see how each part contributes to the total.  Enable faster analysis for your team and gain data driven insights.  Using this visual enables you to break down a metric by the dimensions of your data to see the impact of each.  This can be used for root cause analysis such as failure of parts, operational processes or determining where you highest sales are coming from.

While in Preview mode, you will need to enable the feature in the Power BI options and then restart Power BI.  The screenshot below shows the proper setup.

Decomposition Tree Preview Option

Analyzing Data with a Decomposition Tree

I am using a sample dataset of retail sales.  The sample dataset can be found here – Retail Sales Dataset Download Page

First select the measure you want to explore such as Total Sales.  Then add the columns that you would like to understand that lead to your sales.

In this example, I have retail sales by stores, products, payment type and gender.  Using the decomposition tree allows me to analyze behaviors of customers with a single click.

For example, I want to see the Payment methods and product lines that drives the highest average revenue for Female customers.  I started by added the Total Sales to the Analyze section.  Then added the City, Gender, Payment, Product line, Branch and Customer Type to the Explain By section of the decomposition tree visual.

Decomposition Tree Options

By clicking the plus sign at the end of each blue bar.  I can then choose the next level of data to explore.  In this case, I followed the path of City > Gender > Payment > Product line.  I can now see that most female shoppers use an Ewallet and purchase food and beverages from the Dallas store.

Decomposition Tree Power BI Example

No to see what men are purchasing with EWallets.  I can simply click on the blue bar on Male and then Ewallet to see that they are purchasing sports and travel items.

Decomposition Tree Power BI Example with Highlight

Please try out this great feature that helps you get more value from your data.  Email me with questions.

See it in action – Power BI Decomposition Tree Example – YouTube

Need Power BI Training? – Get Power BI Training in Hours not Days

Looking for Power BI Consulting? – Power BI Quick Start