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
Page tooltips appear on hover over a visual and cannot expand or collapse matrix hierarchy levels. They are tempting because they add contextual detail without altering layout, which suits supplementing KPI values with charts, but the matrix requires its own expand/collapse setting to reveal grouped rows.
- ✓
Drill-down mode
Why this is correct
Drill-down mode lets users navigate the matrix hierarchy by expanding and collapsing category levels, satisfying the requirement to reveal lower-level detail on demand. Enabling it on the visual's axis fields gives the interactive expand/collapse behaviour users need.
- ✗
Drill-through
Why it's wrong here
Drill-through navigates to a separate filtered page for a selected data point; it does not expand or collapse hierarchy levels within the matrix. It is tempting because it reveals deeper detail on demand, which suits investigating a specific region or category, but in-place grouping control needs the matrix's expand/collapse setting.
- ✗
Row and column subtotals
Why it's wrong here
Subtotals display aggregated values at hierarchy levels; they do not add the interactive expand and collapse controls the matrix needs. They are tempting because they summarise grouped data, which suits showing regional totals alongside category detail, but the required behaviour comes from enabling the matrix's expand/collapse option.
About these practice questions
This PL-300 question is part of Courseiva's 524-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: 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.
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.