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.