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

Martha Skjellerup 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

Andy Kristian 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

Akshay 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

Power BI User 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

Kelly Hurtado 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

SUBHOLINA DEB 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

Power BI User 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

Josh Flory 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

Ferri on 05 Jul 2020 22:41:20

RE: Matrix +/- Collapse/ Expand Buttons

Any news???

Sean's profile image Profile Picture

Yash 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.