0
0
Power BIbi_tool~5 mins

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

Choose your learning style9 modes available
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.

Click to reveal answer
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.

Click to reveal answer
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.

Click to reveal answer
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.

Click to reveal answer
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.

Click to reveal answer

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

AYou see more detailed data inside the same visual
BYou open a new report page
CYou export data to Excel
DYou change the visual type

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

ASlicer
BDrill-down
CDrill-through
DBookmark

How do you activate drill-down on a visual?

AClick the drill-down arrow on the visual toolbar
BRight-click and select drill-down
CUse the filter pane
DChange the visual type

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

AA bookmark
BA slicer on the page
CA measure with DAX
DA drill-through filter set on a field

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

ARemoves data from reports
BMakes reports interactive and easier to explore
CAutomatically creates new visuals
DExports data to PDF

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.
You got /4 concepts.

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

    Focus on filters and page setup.
    You got /4 concepts.