Decomposition tree in Power BI - Dashboard Guide

Dashboard Mode - Decomposition tree

Business Question

Which product categories and subcategories contribute most to total sales, and how do regions affect these sales?

Sample Data

Category	Subcategory	Region	Sales
Furniture	Chairs	East	100
Furniture	Tables	West	150
Technology	Phones	East	200
Technology	Accessories	West	120
Office Supplies	Paper	East	80
Office Supplies	Binders	West	90

Dashboard Components

• KPI Card: Total Sales with formula Total Sales = SUM(Sales[Sales]). Result: 740
• Decomposition Tree Visual: Breaks down Total Sales by Category, then Subcategory, then Region. This lets users explore which categories and regions drive sales.
• Table: Shows detailed sales by Category, Subcategory, and Region for reference.

Dashboard Layout

+----------------------+-------------------------+
|      KPI Card        |   Decomposition Tree     |
|   (Total Sales)      |                         |
+----------------------+-------------------------+
|                      |                         |
|       Table          |                         |
| (Sales Details)      |                         |
+----------------------+-------------------------+

Interactivity

The decomposition tree is interactive. Clicking on a Category expands to show Subcategories, then Regions. Selecting a node filters the table below to show only relevant sales details. The KPI card updates dynamically to reflect the filtered total sales.

Self Check

Add a filter to select only the Technology category. Which components update and what is the new total sales?

• The KPI card updates to show total sales for Technology: 320 (Phones 200 + Accessories 120).
• The decomposition tree shows only Technology category branches.
• The table filters to show only Technology sales rows.

Key Result

Interactive decomposition tree dashboard showing total sales broken down by category, subcategory, and region with dynamic KPI and detailed table.

Practice

1. What is the main purpose of a Decomposition tree visual in Power BI?

easy

A. To combine multiple unrelated datasets

B. To create a static summary table of data

C. To display data as a simple bar chart

D. To break down a measure into parts for detailed analysis

Solution

1. Step 1: Understand the function of a decomposition tree

   A decomposition tree helps explore a measure by breaking it down into smaller parts or categories.

2. Step 2: Compare options with this function

   Only To break down a measure into parts for detailed analysis describes breaking down a measure for detailed analysis, which matches the decomposition tree's purpose.

3. Final Answer:

   To break down a measure into parts for detailed analysis -> Option D

4. Quick Check:

   Decomposition tree = Break down measure [OK]

Hint: Think: decomposition means breaking down [OK]

Common Mistakes:

• Confusing decomposition tree with simple charts
• Thinking it creates static tables
• Assuming it merges unrelated data

2. Which of the following is the correct way to add a category to a Decomposition tree visual in Power BI?

easy

A. Drag a field to the 'Explain by' bucket

B. Drag a field to the 'Analyze' bucket

C. Drag a field to the 'Values' bucket

D. Drag a field to the 'Filters' pane

Solution

1. Step 1: Recall Decomposition tree buckets

   The 'Explain by' bucket is where you add categories to break down the measure in the decomposition tree.

2. Step 2: Match options to buckets

   Only Drag a field to the 'Explain by' bucket correctly identifies 'Explain by' as the place to add categories for decomposition.

3. Final Answer:

   Drag a field to the 'Explain by' bucket -> Option A

4. Quick Check:

   'Explain by' = categories in decomposition tree [OK]

Hint: Categories go in 'Explain by' bucket [OK]

Common Mistakes:

• Putting categories in 'Analyze' or 'Values' buckets
• Confusing 'Filters' pane with category placement
• Not knowing bucket names

3. Given a Decomposition tree analyzing total sales by Region and Product Category, what happens when you click on a Region node?

medium

A. It shows a tooltip with total sales for all Regions

B. It filters the entire report to only that Region

C. It drills down to show sales breakdown by Product Category within that Region

D. It resets the tree to show all Regions again

Solution

1. Step 1: Understand interaction in decomposition tree

   Clicking a node drills down to the next category level within that node's context.

2. Step 2: Apply to Region and Product Category

   Clicking a Region shows sales broken down by Product Category inside that Region.

3. Final Answer:

   It drills down to show sales breakdown by Product Category within that Region -> Option C

4. Quick Check:

   Click node = drill down next category [OK]

Hint: Click node to drill down next level [OK]

Common Mistakes:

• Thinking it filters whole report
• Assuming it resets the tree
• Confusing tooltip with drill down

4. You added a Decomposition tree visual but it shows no breakdown when clicking nodes. What is the most likely cause?

medium

A. No categories were added to the 'Explain by' field well

B. The measure used is not numeric

C. The visual is not connected to any data source

D. The report page is filtered to zero rows

Solution

1. Step 1: Check category setup in decomposition tree

   If no categories are in 'Explain by', the tree cannot break down the measure further.

2. Step 2: Evaluate other options

   While measure type and filters matter, the main reason for no breakdown is missing categories.

3. Final Answer:

   No categories were added to the 'Explain by' field well -> Option A

4. Quick Check:

   Missing 'Explain by' categories = no breakdown [OK]

Hint: Always add categories to 'Explain by' [OK]

Common Mistakes:

• Ignoring missing categories
• Blaming measure type first
• Not checking filters

5. You want to analyze sales by Region, then by Product Category, but only for the top 3 Regions by sales. How can you set this up using a Decomposition tree?

hard

A. Add Product Category to 'Explain by' and Region to 'Values' with a slicer for top 3

B. Add Region and Product Category to 'Explain by' and apply a Top N filter on Region by sales

C. Add Region to 'Analyze' and Product Category to 'Explain by' without filters

D. Add Region and Product Category to 'Explain by' and use a measure that sums only top 3 Regions

Solution

1. Step 1: Set categories in 'Explain by'

   Both Region and Product Category should be in 'Explain by' to allow drilling down.

2. Step 2: Apply Top N filter on Region by sales

   Use a Top N filter on Region to limit to top 3 Regions by sales before drilling down.

3. Final Answer:

   Add Region and Product Category to 'Explain by' and apply a Top N filter on Region by sales -> Option B

4. Quick Check:

   Top N filter + categories in 'Explain by' = correct setup [OK]

Hint: Use Top N filter on first category in 'Explain by' [OK]

Common Mistakes:

• Putting categories in wrong buckets
• Not applying Top N filter correctly
• Using measures instead of filters for top N