G_vandeVlist's avatar
G_vandeVlist
New Member
3 years ago
Status:
Completed

Ability to Collapse Individual Rows in Matrix Visual

I would like to have the ability to collapse individual rows in the Matrix visual in Power BI. Currently, we can only collapse or expand all rows at once per entire level. However, it would be highly beneficial if I could collapse specific rows within a level while keeping others expanded. (Same as in a pivot table in Excel)


One specific use case where this feature would come in handy is when I use a Matrix visual with a hierarchy of "Department" to "Type" to "Product". Within the "Type" field, there are two categories, namely "Supply" and "Demand". I would like to have the ability to individually collapse the rows with the "Type" "Supply", displaying only the subtotals, while keeping the rows with the "Type" "Demand" expanded with their respective details.


This feature would enhance the reporting experience by allowing us to hide specific details and display only the desired subtotals. It would provide greater flexibility and improve readability of reports with complex hierarchies.

Recent ideas