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)

7b947cf9 646f-4965-a5e0-a5bb56d4b592 on 05 Jul 2020 22:34:42

RE: Matrix +/- Collapse/ Expand Buttons

survey is closed. does this mean you got lots of feedback?

50bdcdb9 0af1-49a6-9954-3c0ec3a1eec9 on 05 Jul 2020 22:34:15

RE: Matrix +/- Collapse/ Expand Buttons

Another good addition, if it hasn't been mentioned already as part of this feature:

Need the ability to toggle on and off subtotals for a group in the matrix. For example, if I have department, employee name, and employee phone number in a matrix, I shouldn't be able to turn off the subtotal for phone number, or somehow indicate that employee name and employee phone number fields should be grouped together.

d7868583 eec6-441e-885b-07d7698dd86e on 05 Jul 2020 22:33:59

RE: Matrix +/- Collapse/ Expand Buttons

Over a year since this idea enhancement was posted....hmmm how long do you guys need...Is there an enhancement road map for your product like other vendors provide?

f88b2439 60ee-4c04-b0e5-f7d94a2269c7 on 05 Jul 2020 22:33:54

RE: Matrix +/- Collapse/ Expand Buttons

We really need this feature. It would be great. We are migrating from Qlik to PowerBI. Qlik already has this functionality. PowerBI is getting better everyday. Please help us with this feature for a nice transition.

Thanks.