Decomposition tree in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a decomposition tree visual in Power BI.

Power BI

DecompositionTree = [1]()

Drag options to blanks, or click blank then click option'

ADecompositionTreeVisual

BTreeDecomposition

CDecompositionTree

DDecomposeTree

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect visual names like 'TreeDecomposition' or 'DecomposeTree'.

The correct visual object name in Power BI for decomposition tree is DecompositionTree.

2fill in blank

medium

Complete the code to add a measure as the analysis field in the decomposition tree.

Power BI

DecompositionTree.AnalysisField = [1]

Drag options to blanks, or click blank then click option'

ASalesAmount

BTotalSales

CSumSales

DSalesMeasure

Attempts:

3 left

💡 Hint

Common Mistakes

Using measure names that do not exist or are not numeric.

The measure SalesAmount is commonly used as the analysis field in decomposition trees to show sales values.

3fill in blank

hard

Fix the error in the DAX formula to calculate the total sales for the decomposition tree.

Power BI

TotalSales = CALCULATE(SUM(Sales[[1]]))

Drag options to blanks, or click blank then click option'

ATotalAmount

BSaleAmount

CSalesAmount

DAmount

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect column names like 'SalesAmount' which may not exist.

The correct column name inside the Sales table is Amount. The formula sums the Amount column.

4fill in blank

hard

Fill both blanks to filter the decomposition tree to only show data for the year 2023.

Power BI

FILTER(Sales, Sales[[1]] = [2])

Drag options to blanks, or click blank then click option'

AYear

B2023

CMonth

D2022

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'Month' instead of 'Year' or wrong year values.

The filter uses the Year column and the value 2023 to show only that year's data.

5fill in blank

hard

Fill all three blanks to create a decomposition tree that breaks down sales by Region and then by Product Category.

Power BI

DecompositionTree.AddBreakdown([1])
DecompositionTree.AddBreakdown([2])
DecompositionTree.AnalysisField = [3]

Drag options to blanks, or click blank then click option'

ASales[Region]

BSales[ProductCategory]

CSalesAmount

DSales[Date]

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong columns for breakdown or incorrect measure for analysis.

The breakdowns are first by Region then by ProductCategory. The analysis field is the SalesAmount measure.

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