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)

a8b552d9 8bbd-48ba-9c50-04698b1b279e on 05 Jul 2020 23:24:40

RE: Matrix +/- Collapse/ Expand Buttons

It's perfect and very important

6b9cd790 e239-47b8-8dc0-b223057de4be on 05 Jul 2020 23:24:15

RE: Matrix +/- Collapse/ Expand Buttons

i want to create +/- Collapse/ Expand Buttons feature in matrix table but didn't get any solution . Can anyone help me out on this?

6b9cd790 e239-47b8-8dc0-b223057de4be on 05 Jul 2020 23:24:15

RE: Matrix +/- Collapse/ Expand Buttons

This functionality should be enabled in the matrix table. if it is not there, the data readability in side the table will go off.

9b9d8f02 a362-491f-9e5f-6398f9cdac58 on 05 Jul 2020 23:21:48

RE: Matrix +/- Collapse/ Expand Buttons

Great! It would be nice improve the Matrix export to Excel.

34b4779f 0c99-4875-9606-52ca24ba1886 on 05 Jul 2020 23:21:48

RE: Matrix +/- Collapse/ Expand Buttons

Is this idea still relevant given that there is now this powerful PBI feature to drill down both vertically and horizontally wherever you like in the matrix visual?