Power BI

Completed

Matrix +/- Collapse/ Expand Buttons

Vote (3762)

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)

Comments (234)

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

RE: Matrix +/- Collapse/ Expand Buttons

A must!

Paul on 05 Jul 2020 22:18:36

RE: Matrix +/- Collapse/ Expand Buttons

Great idea.

Jason Yang on 05 Jul 2020 22:17:38

RE: Matrix +/- Collapse/ Expand Buttons

This is currently a pain point of powerbi where you can't collapse a matrix as you can do with a pivottable. Can we have this added soon?

Mark Wilcock on 05 Jul 2020 22:17:35

RE: Matrix +/- Collapse/ Expand Buttons

Now we have the hierarchies in the Feb 16 update, this would be a fantastic next step. For example if we created a Region - Country - State hierarachy then add Country to the Matrix Rows, currently we get a row for all countries. Much Better would be to add Region to the Rows then Expand down to the countries in a selected region and so on

Adam Kruzel on 05 Jul 2020 22:16:58

RE: Matrix +/- Collapse/ Expand Buttons

This would be very useful especially when trying to navigate hierarchies!

Sebastian on 05 Jul 2020 22:15:28

RE: Matrix +/- Collapse/ Expand Buttons

This function would be a very useful extension. So please extend the Matrix chart for the collapse/uncollapse function

Dave Robinson on 05 Jul 2020 22:12:48

RE: Matrix +/- Collapse/ Expand Buttons

Expand and collapse feature would be very useful. Also would like the abilty to select a customer within the matrix and have the other visuals slice based on customer select from matrix. This can be done via bar chart but would be way more functional and powerful to be able to select a slicer value within the matrix view.