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

ae82a401 eadb-e711-8114-fc15b428ab70 on 05 Jul 2020 22:42:40

RE: Matrix +/- Collapse/ Expand Buttons

Actually, it works okay. I have downloaded and tested the new desktop. And you do not see the small+ like in an excel file, but it works good - you can see all the levels as if it was excel.

Sean's profile image Profile Picture

5b1497a0 1ee7-4834-bdcb-151bce32b348 on 05 Jul 2020 22:42:39

RE: Matrix +/- Collapse/ Expand Buttons

just download the new installer here guys..
https://www.microsoft.com/en-us/download/details.aspx?id=45331

and here is the full link from email that we all got
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-feature-summary/

Sean's profile image Profile Picture

6ede7c41 282b-44ed-8243-f8bc6572d6ce on 05 Jul 2020 22:42:39

RE: Matrix +/- Collapse/ Expand Buttons

Very depressing that mail sent to redirect to a broken link
there is nothing in that blog please check thrice before sending any mail

Sean's profile image Profile Picture

500e58ec 325e-46e2-b560-f4d1dbabfda9 on 05 Jul 2020 22:42:39

RE: Matrix +/- Collapse/ Expand Buttons

Hi, I tried downloading the new installer, but the Matrix visual preview isn't there.

Thanks

Sean's profile image Profile Picture

425cd9da efa1-40dc-803f-a9c1af106019 on 05 Jul 2020 22:42:10

RE: Matrix +/- Collapse/ Expand Buttons

Yes, I would like to control the amount of subtotals in the matrix! Please add this feature.

Sean's profile image Profile Picture

beddf7d7 d585-4a22-badd-87f4179a6a95 on 05 Jul 2020 22:42:03

RE: Matrix +/- Collapse/ Expand Buttons

Unless this feature will be released we will not be able to close our BI project..Pls let us know when this feature will be added to POWER BI..Why this must have feature is not there till date?

Sean's profile image Profile Picture

e496170a 8cd0-4900-879d-e353ed0e16bc on 05 Jul 2020 22:42:03

RE: Matrix +/- Collapse/ Expand Buttons

Same as drill down possibility, this is a must have !! Please ...?

Sean's profile image Profile Picture

2740f507 1b95-4808-91d9-aaad61c30ac0 on 05 Jul 2020 22:42:01

RE: Matrix +/- Collapse/ Expand Buttons

How can this basic feature still be under review, can we please get an update on this? Thanks! This is blocking rollout to my enterprise.

Sean's profile image Profile Picture

f645da3f 4a4c-4ede-a879-3e59acb6343e on 05 Jul 2020 22:41:20

RE: Matrix +/- Collapse/ Expand Buttons

Any news???

Sean's profile image Profile Picture

bbcf02bf 6a39-49dd-a51b-d62f9325538f on 05 Jul 2020 22:41:20

RE: Matrix +/- Collapse/ Expand Buttons

Any update when this feature will be available?
This feature makes my dashboard lot easier. I do not want to open up all the hierarchy values opened up everytime, this will help our users just to drill up/down only when they need.