Skip to main content

Power BI

Completed

Matrix +/- Collapse/ Expand Buttons

Vote (3762) Share
Sean's profile image

Sean on 07 Aug 2015 03:38:36

Please add Collapse/Expand buttons in the Matrix Visualizations. Otherwise when all fields are expanded by default the user would have to scroll a lot to find what they are looking for. I could add a slicer to take user to the data they are looking for but then the rest of the data in the matrix disappears and more specifically the overall totals change!Expand/Collapse buttons would keep the overall totals as intended and totals for other fields while allowing the user to only expand the field they are interested in. Also ability to do conditional formatting for a specific field in the matrix would be nice. Thanks!

Administrator on 17 Nov 2018 02:34:25

With our November update of Power BI Desktop, you can now expand/collapse matrix row headers. You can read more on our blog: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/#expandCollapse A few people were asking about column headers. As some of the work involved for column headers is different than row headers, we want to understand how many users specifically need/want column header support as well. If you need column header support, please vote on this idea that I added to UserVoice: https://ideas.powerbi.com/forums/265200/suggestions/36038050

Comments (234)
Sean's profile image Profile Picture

Eran Sagi on 05 Jul 2020 22:23:48

RE: Matrix +/- Collapse/ Expand Buttons

When using Hiearchies within a Matrix chart, it would be good visulaization if the cuser can Collapse and Expend the levels of the Hierarchiy

Sean's profile image Profile Picture

Simon on 05 Jul 2020 22:23:29

RE: Matrix +/- Collapse/ Expand Buttons

Yes would definitely like to see this soon.

Sean's profile image Profile Picture

Andy on 05 Jul 2020 22:23:28

RE: Matrix +/- Collapse/ Expand Buttons

Yes, definitely. I'm trying to create a matrix with Year - Month - Day and need to collapse by default to Year and Month.

Sean's profile image Profile Picture

srikar beeravally on 05 Jul 2020 22:23:01

RE: Matrix +/- Collapse/ Expand Buttons

must needed feature, Please update. Thanks

Sean's profile image Profile Picture

Marco Abergo on 05 Jul 2020 22:23:01

RE: Matrix +/- Collapse/ Expand Buttons

I totally agree. It could be an important step forward to improve the most important kind of visualizzation to analyze data. Graphics visualization are amazing but the user wants view and analyze data and numbers.
At the moment Matrix is the only/best solution to do that but a lot of features are missing: drill down, collapse-expand etc.

Sean's profile image Profile Picture

Erika Steffins on 05 Jul 2020 22:22:46

RE: Matrix +/- Collapse/ Expand Buttons

This is a function that I can't understand why it would not have been added at the introduction of the Matrix visualization. This is a major point on why I have not integrated many of my reports to Power BI. It is not useful for my staff to look at a giant table/matrix of data, yet it is also not useful if they cannot drill down in a table/matrix either. This is already a standard feature in excel with pivot tables, can this same principle not be applied to the matrix in Power BI?

Sean's profile image Profile Picture

Power BI User on 05 Jul 2020 22:22:05

RE: Matrix +/- Collapse/ Expand Buttons

You really lack this function! It's a must have...

Sean's profile image Profile Picture

Power BI User on 05 Jul 2020 22:22:01

RE: Matrix +/- Collapse/ Expand Buttons

It is Must needed feature

Sean's profile image Profile Picture

srikar beeravally on 05 Jul 2020 22:21:50

RE: Matrix +/- Collapse/ Expand Buttons

Must Needed

Sean's profile image Profile Picture

Robin on 05 Jul 2020 22:21:48

RE: Matrix +/- Collapse/ Expand Buttons

"Soonest" pretty please!