Hey Doug, this is such a common pain point for folks new to Power BI matrices—let’s get this fixed for you right away. The issue you’re seeing is just the default drill behavior kicking in, but it’s super easy to adjust so you keep all parent rows visible when expanding child levels. Here’s how:

1. Use Expand/Collapse Icons Instead of Drill Down #

The default drill-down action filters the matrix to only show the parent of the item you’re drilling into. Instead, look for the small triangle icons next to each row header (if you don’t see them, go to the Visualizations pane > Format > Row headers > Toggle on "Expand/collapse icons"). Clicking these triangles expands just that specific parent row while leaving all other parent rows fully visible in the matrix.

2. Adjust Drill Settings to Keep All Parents Visible #

If you prefer using the drill icon (the downward arrow) but still want to retain all parent rows:

• Select your matrix visual.
• Open the Format pane (the paintbrush icon on the right).
• Navigate to Visual > Drilling.
• Toggle off the "Keep only one level expanded" option. Now when you drill into a child level, all other parent rows will stay in view instead of being filtered out.

3. Double-Check Your Hierarchy Setup #

Quick sanity check: Make sure your row hierarchy is properly structured in the Fields pane. Add all levels of your hierarchy (e.g., Category > Subcategory > Product) to the Rows section in the correct order. A misordered hierarchy can cause unexpected behavior when expanding/drilling.

Pro tip: If you want to give your users flexibility, you can add a dedicated "Drill" button from the Insert tab and set its action to either "Drill Down" or "Expand"—this lets them switch between behaviors without changing the visual’s default settings.

内容的提问来源于stack exchange，提问作者Doug