Enable Expand and Collapse in Power BI Matrix Visual
You have a Power BI report with a matrix visual showing sales by region and product category. You want to allow users to expand and collapse groups. Which feature should you enable?
Quick Answer
The answer is to enable row and column subtotals. This is correct because the expand and collapse functionality in a Power BI matrix visual relies on a defined hierarchy in the rows or columns, and the subtotals feature must be active for the plus/minus icons to appear, allowing users to toggle between aggregated and detailed data. On the PL-300 exam, this concept tests your understanding of matrix visual behavior versus other navigation features; a common trap is confusing expand/collapse with drill-down (which changes the hierarchy level) or drill-through (which navigates to a different page). Remember that subtotals are the gatekeeper for expand/collapse—if they are turned off, the hierarchy icons disappear. A useful memory tip: "Subtotals unlock the plus signs."
⚠ Common exam trap
Candidates often mistake subtotals for enabling expand/collapse, but subtotals are a separate formatting setting. Expand/collapse is inherently tied to hierarchical data and drill-down mode.
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 mode
Drill-down mode in a matrix visual allows users to expand and collapse hierarchical levels. When a hierarchy is present, enabling drill-down mode provides expand/collapse icons on row headers, letting users interactively show or hide subcategories. Option A (page tooltips) shows tooltip pages on hover, unrelated to expand/collapse. Option C (drill-through) navigates to another report page, not within the same visual. Option D (row and column subtotals) is a formatting feature for aggregating totals, not for expanding/collapsing groups.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Page tooltips
Why it's wrong here
Incorrect. Page tooltips display a tooltip page when hovering over a data point; they do not enable expand/collapse of groups.
- ✓
Drill-down mode
Why this is correct
Correct. Drill-down mode provides expand/collapse buttons on hierarchical row headers, allowing users to navigate the hierarchy.
- ✗
Drill-through
Why it's wrong here
Incorrect. Drill-through navigates to a different report page filtered by the selected data point; it does not affect the matrix's expand/collapse behavior.
- ✗
Row and column subtotals
Why it's wrong here
Incorrect. Row and column subtotals are formatting options to show or hide subtotal rows and columns; they do not enable expand/collapse.
Go deeper
Related to this question
About these practice questions
This PL-300 question is part of Courseiva's 217-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
Same concept, more angles
1 more way this is tested on PL-300
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. 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?
medium- A.Set up drill-through pages for each quarter
- B.Create bookmarks for each level
- ✓ C.Enable drill-down mode and add a hierarchy of Year and Quarter
- D.Add a tooltip page showing quarterly details
Why C: Enable drill-down mode and add a hierarchy of Year and Quarter. Drill-down mode on a matrix visual allows users to expand and collapse hierarchical levels interactively. Adding a hierarchy of Year and Quarter enables navigating from higher to lower levels. Option A is incorrect because drill-through pages navigate to a separate page to show more details, not drill down within the same visual. Option B is incorrect because bookmarks capture static states and do not provide interactive drill-down behavior. Option D is incorrect because tooltip pages show additional details on hover but do not support hierarchical navigation.
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.