Drill-down and drill-through in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is drill-down in Power BI?

Drill-down lets you click on a chart to see more detailed data inside the same visual. It’s like zooming in to see smaller parts of a big picture.

beginner

What does drill-through do in Power BI?

Drill-through lets you click on a data point and open a new page with detailed information filtered for that point. It’s like going to a new room to learn more about one thing.

beginner

How do you enable drill-down on a visual?

You turn on the drill-down button (a small arrow) on the visual’s top bar. Then clicking on parts of the visual shows more detailed levels.

intermediate

What is a drill-through filter?

A drill-through filter is a special filter on the drill-through page that shows data only for the item you clicked on in the main report.

beginner

Why use drill-down and drill-through in reports?

They help users explore data easily. Drill-down shows details inside one chart. Drill-through opens a focused page for deeper analysis. Both make reports interactive and clear.

What happens when you use drill-down on a Power BI visual?

A You see more detailed data inside the same visual

B You open a new report page

C You export data to Excel

D You change the visual type

Drill-down lets you explore more detailed data inside the same visual by clicking on it.

Which feature lets you open a new page filtered by the clicked data point?

A Slicer

B Drill-down

C Drill-through

D Bookmark

Drill-through opens a new page filtered for the selected data point.

How do you activate drill-down on a visual?

A Click the drill-down arrow on the visual toolbar

B Right-click and select drill-down

C Use the filter pane

D Change the visual type

The drill-down arrow on the visual toolbar enables drill-down interaction.

What is required on a drill-through page to filter data correctly?

A A bookmark

B A slicer on the page

C A measure with DAX

D A drill-through filter set on a field

A drill-through filter on a field ensures the page shows data related to the clicked item.

Which is a benefit of using drill-down and drill-through?

A Removes data from reports

B Makes reports interactive and easier to explore

C Automatically creates new visuals

D Exports data to PDF

Drill-down and drill-through improve report interactivity and help users explore data easily.

Explain the difference between drill-down and drill-through in Power BI.

Think about whether you stay on the same page or move to a new page.

Describe how to set up a drill-through page in Power BI.

Focus on filters and page setup.

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