Drill-down and drill-through in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to enable drill-down on a visual by turning on the {{BLANK_1}} feature.

Power BI

VisualInteractions.DrillDown = [1]

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

Afalse

Bnull

Ctrue

Denabled

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'false' disables drill-down.

Using 'null' or 'enabled' are not valid boolean values.

Turning on true enables drill-down interaction on the visual.

2fill in blank

medium

Complete the DAX expression to create a drill-through filter that passes the selected {{BLANK_1}} value.

Power BI

FILTER(ALL('Sales'), 'Sales'[[1]] = SELECTEDVALUE('Summary'[[1]]))

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

ARegion

BCustomer

CDate

DProduct

Attempts:

3 left

💡 Hint

Common Mistakes

Using a column not present in both tables.

Using a date column when the drill-through is by product.

The drill-through filter uses the Product column to pass the selected product value to the target page.

3fill in blank

hard

Fix the error in the DAX measure to correctly calculate total sales for the drill-through page using {{BLANK_1}}.

Power BI

TotalSales = CALCULATE(SUM('Sales'[Amount]), [1])

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

AFILTER('Sales', 'Sales'[Product] = SELECTEDVALUE('Product'[Product]))

BFILTER(ALL('Sales'), 'Sales'[Product] = SELECTEDVALUE('Product'[Product]))

CALL('Sales')

DREMOVEFILTERS('Sales')

Attempts:

3 left

💡 Hint

Common Mistakes

Using ALL without FILTER loses the filter context.

Using REMOVEFILTERS removes all filters, ignoring drill-through.

The correct filter uses FILTER(ALL('Sales'), ...) to apply the drill-through filter context properly.

4fill in blank

hard

Fill both blanks to create a drill-through button that navigates to the {{BLANK_1}} page and passes the {{BLANK_2}} filter.

Power BI

Button.OnClick = Navigate('[1]', { '[2]': SELECTEDVALUE('Table'[[2]]) })

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

ADetails

BRegion

CSummary

DProduct

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping page name and filter column.

Using a page name that does not exist.

The button navigates to the Details page and passes the Product filter for drill-through.

5fill in blank

hard

Fill all three blanks to create a drill-down hierarchy with levels {{BLANK_1}}, {{BLANK_2}}, and {{BLANK_3}}.

Power BI

Hierarchy = { '[1]', '[2]', '[3]' }

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

ACountry

BCity

CCategory

DSubcategory

Attempts:

3 left

💡 Hint

Common Mistakes

Using Category instead of City in the middle level.

Ordering levels incorrectly.

The drill-down hierarchy is set as Country > City > Subcategory for detailed analysis.