PL-300 Drillthrough Practice Question
You are designing a report for executives. They need to see both high-level KPIs and the ability to drill down into details. Which approach should you recommend?
⚠ Common exam trap
The question tests the distinction between drillthrough (navigating to a dedicated detail page) and drill-down (expanding within the same visual). Drillthrough is better for providing rich detail while keeping the summary clean.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use drillthrough pages to navigate from summary visuals to detail pages.
Option B is correct because drillthrough pages are purpose-built for this scenario: a user right-clicks a data point on a summary visual (such as a KPI card or chart) and navigates to a separate detail page filtered to that context, preserving the summary-to-detail flow executives need. This keeps the executive page clean with high-level KPIs while providing a dedicated, context-filtered detail page on demand. Option A is wrong because cramming all data into one table with drill-down does not deliver a true high-level KPI view and becomes unwieldy. Option C is wrong because bookmarks merely toggle saved view states and do not pass the selected data context to a detail view. Option D is wrong because report page tooltips only show supplementary information on hover and are not a navigation mechanism for drilling into detail.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Place all data in a single table visual with drill-down capability.
Why it's wrong here
A single table visual with drill-down capability forces users to begin with the most granular rows and manually expand hierarchies to reach aggregate totals, which is the opposite of an executive KPI summary. It overwhelms the audience with raw transactional data and lacks the separation between high-level metrics and contextual detail required for strategic decision-making. Drill-down in a table is a data exploration convenience, not a curated navigation experience.
- ✓
Use drillthrough pages to navigate from summary visuals to detail pages.
Why this is correct
Drillthrough pages are designed for cross-level navigation: the source visual defines a drillthrough field, and when a user right-clicks or clicks with drillthrough enabled, Power BI passes that field's value as a filter to the destination page. This preserves the selected data point's context automatically, allowing the detail page to show only related information while executives start from a clean KPI overview. A back button returns them to the originating page, giving a fluid, context-aware drill-down workflow that bookmarks and tooltips cannot match.
- ✗
Use bookmarks to switch between summary and detail views.
Why it's wrong here
Bookmarks only capture the current state of filters, slicers, and visual settings, letting users manually jump between predefined views. They do not inherit the context of the clicked data point, so an executive clicking a specific region would not automatically see details for that region. Unlike drillthrough, bookmarks require extra UI elements and provide no built-in back-navigation or filtering semantics, making them an indirect and less maintainable navigation mechanism.
- ✗
Use report page tooltips to show details on hover.
Why it's wrong here
Report page tooltips are lightweight hover panels limited to a single page-sized layout with constrained width and height, typically used for quick supplementary information. They cannot render a full detail page with multiple visuals, nor do they support interactive actions like drillthrough or cross-filtering navigation. For executives needing comprehensive drill-in analysis, hovering for details is neither scalable nor equivalent to a dedicated drillthrough page.
Go deeper
Related to this question
About these practice questions
One of 524 original PL-300 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PL-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-300 exam.