Decomposition tree in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a Decomposition tree in Power BI?

A Decomposition tree is a visual that helps break down a measure or dimension into its contributing parts, allowing you to explore data by drilling down into categories step-by-step.

beginner

How do you start analyzing data with a Decomposition tree?

You start by selecting a measure or value to analyze, then choose categories to break down the data, drilling down into details interactively.

intermediate

What is the difference between 'Explain by' and 'Analyze' in a Decomposition tree?

'Explain by' lets you choose fields to break down the data manually, while 'Analyze' uses AI to suggest the most important factors automatically.

intermediate

Can you use a Decomposition tree to find the biggest contributors to a sales drop?

Yes, by drilling down into categories like product, region, or time, you can identify which parts caused the sales drop.

beginner

What is a best practice when using a Decomposition tree?

Limit the number of breakdown categories to keep the tree clear and easy to understand. Use meaningful categories that relate to your question.

What does a Decomposition tree primarily help you do?

A Write complex DAX formulas

B Break down data into smaller parts interactively

C Create static charts with fixed categories

D Import data from Excel

A Decomposition tree lets you explore data by breaking it down into parts step-by-step.

Which feature in the Decomposition tree suggests important factors automatically?

A Analyze

B Explain by

C Manual drill down

D Filter pane

'Analyze' uses AI to suggest key factors to explore in the tree.

What type of data can you analyze with a Decomposition tree?

A Only text data

B Images

C Only dates

D Measures or numeric values

Decomposition trees analyze numeric values or measures by breaking them down by categories.

How do you interact with a Decomposition tree in Power BI?

A By typing SQL queries

B By dragging and dropping visuals

C By clicking categories to drill down

D By changing report themes

You click on categories in the tree to drill down and explore data details.

Why should you limit the number of breakdown categories in a Decomposition tree?

A To keep the tree clear and easy to understand

B To avoid slow report loading

C Because Power BI limits categories to three

D To prevent data loss

Too many categories make the tree confusing; limiting them keeps it clear.

Explain how a Decomposition tree helps in analyzing business data.

Think about how you explore a big problem by looking at smaller pieces.

Describe best practices for using a Decomposition tree effectively.

Consider what makes a visual easy to understand and useful.

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