PL-300 Visualize and analyze the data Practice Question
You need to design a report that allows users to drill from a yearly sales summary to quarterly details, then to monthly details, while maintaining the ability to go back. Which visual interaction should you enable?
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
✓
Drill-down
Drill-down (option C) is correct because it lets users navigate a single visual's hierarchy from a yearly summary to quarterly and then monthly levels while preserving the ability to go back up the hierarchy. This matches the requirement of moving through levels of the same data rather than jumping to a separate page or filtering via saved states. Bookmarks (A) capture and restore view states but do not provide hierarchical level navigation. Tooltips (B) show supplementary detail on hover and do not change the visual's level. Drillthrough (D) navigates to a separate detail page filtered by a selected value, not down a hierarchy within the same visual.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Bookmarks
Why it's wrong here
Bookmarks in Power BI are snapshots of a report page's current state, including applied filters, slicers, and the visibility or configuration of visuals, and they can be triggered via the Bookmarks pane or buttons. However, bookmarks do not implement hierarchical navigation because they cannot expand or collapse levels within a visual's data hierarchy; they only restore a previously saved view. Even if you bookmark a drilled-down state, you cannot provide an interactive back button to return to the parent level unless you separately bookmark that parent state, which is clunky and not a genuine drill experience.
- ✗
Tooltips
Why it's wrong here
Report page tooltips are small, hover-triggered mini-pages that appear when a user points to a data point, displaying additional contextual details without changing the main visual. They are purely informational and passive; they cannot expand an axis to reveal child levels, nor do they provide a hierarchy breadcrumb or back button. Unlike drill-down, tooltips do not modify the field composition or grouping of the visual you are interacting with, so they are unsuitable for the requirement to move from a higher to a lower hierarchical level.
- ✓
Drill-down
Why this is correct
Drill-down is the native hierarchy navigation feature in Power BI visuals such as bar charts, column charts, line charts, and matrixes. When a visual has multiple fields in its axis or rows, the drill-down icons (double down arrow for next level, double up arrow for parent level) appear in the visual's upper-right corner, allowing users to expand one level at a time or return to a previous level with a back button. This behavior is specifically designed for hierarchical exploration, enabling users to start with a high-level summary and progressively drill to granular detail while staying within the same visual, exactly matching the report requirement.
- ✗
Drillthrough
Why it's wrong here
Drillthrough in Power BI is a page-level navigation technique that sends the user to a separate detail page, often filtered by the selected data point, when they right-click or double-click a visual. It does not preserve the visual hierarchy or provide an in-visual back button; instead, the user is taken to an entirely different report page and must navigate back using the browser back button or a custom drillthrough button. This is appropriate for showing related details about a single entity, such as a customer or product, but it is not a mechanism for expanding hierarchies within a singular visual.
Go deeper
Related to this question
About these practice questions
Courseiva writes every PL-300 question from scratch — 524 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. 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.