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.

Practice

1. What is the main difference between drill-down and drill-through in Power BI?

easy

A. Drill-down explores data levels within the same visual, drill-through navigates to another page.

B. Drill-down creates new visuals, drill-through deletes existing visuals.

C. Drill-down filters the entire report, drill-through filters only one visual.

D. Drill-down exports data, drill-through imports data.

Solution

1. Step 1: Understand drill-down functionality

   Drill-down lets you explore different levels of data hierarchy inside the same visual, like going from year to month.

2. Step 2: Understand drill-through functionality

   Drill-through takes you to a different report page filtered by the selected data point, focusing on details.

3. Final Answer:

   Drill-down explores data levels within the same visual, drill-through navigates to another page. -> Option A

4. Quick Check:

   Drill-down = same visual levels, Drill-through = different page [OK]

Hint: Drill-down stays on page; drill-through jumps to another page [OK]

Common Mistakes:

• Confusing drill-down with drill-through navigation
• Thinking drill-down changes pages
• Assuming drill-through modifies the same visual

2. Which of the following is the correct way to enable drill-through on a report page in Power BI?

easy

A. Use the 'Export Data' option on the source visual.

B. Create a new visual and enable drill-down in its format settings.

C. Add a drill-through filter field to the Drill-through filters pane on the target page.

D. Add a slicer to the source page and link it to the target page.

Solution

1. Step 1: Identify drill-through setup

   To enable drill-through, you must add a field to the Drill-through filters pane on the target page to receive filter context.

2. Step 2: Check other options

   Options B, C, and D do not correctly enable drill-through functionality.

3. Final Answer:

   Add a drill-through filter field to the Drill-through filters pane on the target page. -> Option C

4. Quick Check:

   Drill-through filter field setup = Add a drill-through filter field to the Drill-through filters pane on the target page. [OK]

Hint: Drill-through needs filter field on target page filters pane [OK]

Common Mistakes:

• Trying to enable drill-through on source page instead of target
• Confusing drill-down format settings with drill-through setup
• Using slicers instead of drill-through filters

3. Given a bar chart with Year > Quarter > Month hierarchy enabled for drill-down, what happens when you click the drill-down button and then select a year bar?

medium

A. The report navigates to a new page filtered by the selected year.

B. The chart shows quarters for the selected year within the same visual.

C. The chart exports data for the selected year.

D. Nothing happens because drill-down is disabled.

Solution

1. Step 1: Understand drill-down behavior on hierarchy

   Clicking drill-down and selecting a year drills into the next level, showing quarters for that year in the same visual.

2. Step 2: Eliminate other options

   The report navigates to a new page filtered by the selected year. describes drill-through, not drill-down. The chart exports data for the selected year. is unrelated. Nothing happens because drill-down is disabled. contradicts the question setup.

3. Final Answer:

   The chart shows quarters for the selected year within the same visual. -> Option B

4. Quick Check:

   Drill-down moves down hierarchy in same visual [OK]

Hint: Drill-down moves inside visual hierarchy levels [OK]

Common Mistakes:

• Confusing drill-down with drill-through navigation
• Expecting page change on drill-down
• Ignoring hierarchy levels in drill-down

4. You set up a drill-through page but clicking the drill-through option on the source visual does nothing. What is the most likely cause?

medium

A. The drill-through filter field is missing on the target page.

B. The source visual does not have any data points.

C. The drill-down button is enabled instead of drill-through.

D. The report page is not published.

Solution

1. Step 1: Check drill-through setup requirements

   Drill-through requires a filter field on the target page to receive context from the source visual.

2. Step 2: Analyze other options

   The source visual does not have any data points. might affect visuals but not drill-through availability. The drill-down button is enabled instead of drill-through. confuses drill-down with drill-through. The report page is not published. is unrelated to drill-through functionality.

3. Final Answer:

   The drill-through filter field is missing on the target page. -> Option A

4. Quick Check:

   Missing drill-through filter field blocks drill-through [OK]

Hint: Always add drill-through filter field on target page [OK]

Common Mistakes:

• Confusing drill-down and drill-through buttons
• Not adding filter field on target page
• Assuming drill-through works without data

5. You want to create a report where users can drill-down from Region to Country to City in a map visual, and also drill-through to a detailed sales page filtered by City. Which setup is correct?

hard

A. Create separate visuals for each level and link them with bookmarks.

B. Add City as a slicer on the main page and enable drill-down on the detailed page.

C. Use drill-through filters on the map visual and disable drill-down.

D. Enable hierarchy drill-down on the map visual and add City as a drill-through filter on the detailed page.

Solution

1. Step 1: Setup drill-down hierarchy on map visual

   Enable hierarchy drill-down from Region to Country to City so users can explore levels inside the same visual.

2. Step 2: Setup drill-through filter on detailed page

   Add City as a drill-through filter on the detailed sales page to allow navigation filtered by City.

3. Step 3: Confirm other options are incorrect

   Add City as a slicer on the main page and enable drill-down on the detailed page. misplaces drill-down on detailed page. Use drill-through filters on the map visual and disable drill-down. disables drill-down incorrectly. Create separate visuals for each level and link them with bookmarks. uses bookmarks, which is not drill-down or drill-through.

4. Final Answer:

   Enable hierarchy drill-down on the map visual and add City as a drill-through filter on the detailed page. -> Option D

5. Quick Check:

   Drill-down + drill-through setup = Enable hierarchy drill-down on the map visual and add City as a drill-through filter on the detailed page. [OK]

Hint: Combine drill-down hierarchy and drill-through filter for best UX [OK]

Common Mistakes:

• Confusing where to enable drill-down vs drill-through
• Not adding drill-through filter on target page
• Using bookmarks instead of drill-through