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

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:35:25

RE: Matrix +/- Collapse/ Expand Buttons

Disappointing that this is not available for MD. Tableau seems to handle this functionality very well with MD so you would expect PowerBI, another Microsoft product, to provide the same functionality.

Sean's profile image Profile Picture

da080a07 1234-497b-8fa9-b5e2733d4afb on 05 Jul 2020 23:35:11

RE: Matrix +/- Collapse/ Expand Buttons

GREAT GREAT improvement! Thanks Amanda.

Sean's profile image Profile Picture

c4618e18 3c8d-4c63-8ec0-3c3a75bbc1ea on 05 Jul 2020 23:35:11

RE: Matrix +/- Collapse/ Expand Buttons

Tried it today, and it works great! Thx

Sean's profile image Profile Picture

a474b6f6 a706-45df-896e-3e7e46f004e9 on 05 Jul 2020 23:35:01

RE: Matrix +/- Collapse/ Expand Buttons

Great job but Need this for column headers as well!

Sean's profile image Profile Picture

dbd9b92d 8010-4a1d-af1e-1610685e655c on 05 Jul 2020 23:35:01

RE: Matrix +/- Collapse/ Expand Buttons

I also need this for column headers as well - please

Sean's profile image Profile Picture

41aafb81 68bd-4172-8173-8f96ab2628a2 on 05 Jul 2020 23:35:01

RE: Matrix +/- Collapse/ Expand Buttons

Same here... we discussed a case on Monday. Weeks in the columns and the possibility to +(show) the single days of only the last week.

Expected this would be possible...

Sean's profile image Profile Picture

7446722b 3791-46fc-a76c-00a7d68d0866 on 05 Jul 2020 23:34:58

RE: Matrix +/- Collapse/ Expand Buttons

Need this for column headers as well.

Sean's profile image Profile Picture

1ed2d55c 952c-4847-99f9-d9b0028878d2 on 05 Jul 2020 23:34:56

RE: Matrix +/- Collapse/ Expand Buttons

My excitement got crush today that this feature is not supported for multidimensional models. This a long awaited feature, especially for Excel fans. Now my customers are totally disapointed with the limitation.

When can we expect this functionality for MD?

Sean's profile image Profile Picture

826c27bb f951-4623-ae41-1d7d54541a2a on 05 Jul 2020 23:34:34

RE: Matrix +/- Collapse/ Expand Buttons

And when is this going to be released!?!? And more importantly, when is MS going to include totals in Matrix exports to Excel??? It is ridiculous that this is not possible - its all MS apps!!! This is a deal breaker at the financial firm I work in.

Sean's profile image Profile Picture

ceb7d690 2fcc-409f-8454-2b6ebad95206 on 05 Jul 2020 23:34:27

RE: Matrix +/- Collapse/ Expand Buttons

Mhè?! When will this feature be added?!