Home / Power BI / How to Expand & Collapse Matrix Row Headers in Power BI

How to Expand & Collapse Matrix Row Headers in Power BI

Social Shares

In this blog, I am willing to explain how to expand /collapse row headers in matrix visualization. This is the most important feature in Microsoft Power BI  which I thought to pen down for you all.


There are two ways you can expand/collapse row headers in matrix visualization. The first way is to take the route of the Right-click menu. Post this, you will be able to see options to expand/Collapse the specific record or row you clicked on, entire level or all down to the very last level of the hierarchy. In a similar way, you can collapse row headers as well.


Right- Click -> Expand/Collapse


Expand


Country Wise Sheet


Also, you can add +/- buttons to the row headers through the formatting pane under the row headers card. By default, the icons will match the formatting of the row header. Additionally, you can format it with the color and size.


Region Sheet


Once you have turned on the icons, it will work similarly to the icons of drill-down.


Region Wise Sheet

Author

  • Kamal brings over 20 years of experience in data analytics and business intelligence. He has led the design and implementation of analytics solutions across operations, financial reporting, and performance improvement initiatives. With a background in business statistics and Six Sigma, his work focuses on applying data in a structured and practical way to solve real business challenges.

Decision-Ready Analytics

Turn your OEE dashboard into a decision system.

Book a 30-minute working session with our manufacturing analytics team.
Translate »