PL-300 Visualize and analyze the data Practice Question
You create a Power BI report that includes a page with a matrix visual showing sales by region and product category. You want users to be able to drill down from region to salesperson level. What is the best way to enable this?
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
✓
Add the Salesperson field to the matrix rows hierarchy below Region.
The correct option is C: adding the Salesperson field to the matrix rows hierarchy below Region. In a Power BI matrix visual, placing fields in a hierarchy within the Rows well enables the built-in drill-down/expand feature, letting users go from region to salesperson level directly in the same visual. Drill-through (A) navigates to a separate detail page rather than drilling within the matrix, bookmarks (B) only toggle saved view states and do not create a hierarchy, and tooltips (D) merely display supplemental information on hover without enabling drill-down.
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 from the region to a salesperson detail page.
Why it's wrong here
Drill-through is a cross-page navigation action defined on the source visual and a target detail page, not a row-expansion mechanism. In this scenario, clicking a region would launch the salesperson detail page (passing the region value as a filter) rather than expanding the current matrix's Region rows to reveal Salesperson rows in-place, so it cannot satisfy the drill-down requirement within the same matrix.
- ✗
Use bookmarks to switch between region and salesperson views.
Why it's wrong here
Bookmarks capture and restore saved visual states, including expanded/collapsed levels, but they require manually pre-defining and toggling separate states rather than enabling interactive drill-down on the fly. To mimic drill-down with bookmarks, you would need to duplicate or resize visuals and manage visibility, and the native +/− expansion affordance (which comes from a row hierarchy) would still be absent, making this an inefficient and non-native approximation.
- ✓
Add the Salesperson field to the matrix rows hierarchy below Region.
Why this is correct
Adding Salesperson to the matrix rows hierarchy below Region creates a two-level row hierarchy: each Region row gains an expand/collapse (+) icon, and users can drill down to see individual salespeople within that region. This is the only option that leverages the matrix's built-in drill-down capabilities, because Power BI interprets multiple fields in the Rows area as hierarchical levels, enabling interactive expand/collapse and also the drill-down/up icons on the visual header.
- ✗
Enable tooltips that show salesperson details on hover.
Why it's wrong here
Report page tooltips (or default tooltips) display supplementary details on hover, but they do not alter the granularity or hierarchy of the matrix rows. A tooltip showing salesperson details would be a transient overlay that disappears when the mouse moves away, and it would never let the user 'drill down' to persist a salesperson-level view in the matrix itself, so it is a convenience feature rather than a drill-down mechanism.
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.