PL-300 Visualize and analyze the data Practice Question
You have a Power BI report with a matrix visual showing sales by year and quarter. Users want to drill down from year to quarter and expand back up. Which feature 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
✓
Enable drill-down mode and add a hierarchy of Year and Quarter
The correct option is C: enable drill-down mode and add a hierarchy of Year and Quarter. Drill-down requires a hierarchy (Year > Quarter) placed on the matrix rows, and enabling drill-down mode lets users expand from year to quarter and collapse back up within the same visual. Drill-through pages (A) navigate to a separate filtered page rather than expanding levels in place, and bookmarks (B) capture view states rather than providing hierarchical navigation. Tooltip pages (D) only show supplemental detail on hover and do not support drill-down or expand-up behavior.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Set up drill-through pages for each quarter
Why it's wrong here
Drill-through pages are designed for cross-page navigation, not for expanding or collapsing hierarchy levels within a single visual. Setting up a separate page for each quarter would require the user to leave the current matrix entirely, breaking the flow of exploration, and each page would only show a static filtered view rather than an interactive drillable structure.
- ✗
Create bookmarks for each level
Why it's wrong here
Bookmarks can store a matrix visual's expanded/collapsed state, but they are static snapshots; they do not give the user the ability to dynamically drill down or collapse levels on the fly. Creating a bookmark for every hierarchy level is tedious and forces the user to click each bookmark to change the view, which is far less intuitive than using the native drill-down icons in the matrix.
- ✓
Enable drill-down mode and add a hierarchy of Year and Quarter
Why this is correct
Enabling drill-down mode and adding a Year and Quarter hierarchy to the matrix is the correct approach because it leverages Power BI's built-in hierarchy expansion and contraction. When the visual is in drill-down mode, the user can click the expand/collapse icons or right-click to move between Year, Quarter, and lower levels seamlessly, without changing pages or relying on static snapshots. This native functionality is exactly what the user needs for interactive level-by-level exploration.
- ✗
Add a tooltip page showing quarterly details
Why it's wrong here
A tooltip page shows additional contextual details when hovering over a data point, but it cannot alter the level of detail displayed in the matrix. Tooltips are purely informational overlays and never provide expand/collapse controls, so while they might enrich the view with quarterly numbers, they do not support the required drill-down behavior.
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.