Skip to main content

Power BI

Under Review

Add expand/collapse feature to column headers

Vote (10428) Share
Amanda Rivera (SHE/HER)'s profile image

Amanda Rivera (SHE/HER) on 17 Nov 2018 02:30:35

Vote on this idea if you want expand/collapse on column headers in the matrix similar to what was shipped for row headers in November (https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/#expandCollapse).

Administrator on 28 Jan 2023 20:33:12

10/20/2022 - Just an update, this is an extremely expensive item, which is why it has not been picked up yet. I promise we will revisit this after we ship visual calculations

Comments (182)
Amanda Rivera (SHE/HER)'s profile image Profile Picture

Robert Hawke on 08 May 2023 16:35:08

RE: Add expand/collapse feature to column headers

This idea is the perfect representation of the entire idea and feature process at Microsoft. This is not rocket science. If they can do it on rows, they can do it on headers. BUT: 1) It is nothing they can use to sell more licenses, advertise, throw into marketing videos ("We can do +/- on columns" isn't a great sign of how innovative we are compared to "look at our cool new AI feature") 2) It is also no "brilliant new idea" that developers/managers get excited about, something that you are proud to work on and be part of the team and therefore internally pushing (like probably on-object editing which I'm sure some people internally are extremely excited about). Developers also want to do new cool things, not work on adding a "boring feature" that Excel 2000 was already able to do. And therefore, these usability improvements, that frustrate thousands to millions of users, just don't get any priority or resources, no matter how much we all complain here.

Amanda Rivera (SHE/HER)'s profile image Profile Picture

Stanley Kusmier Jr on 29 Mar 2023 14:41:51

RE: Add expand/collapse feature to column headers

This is a feature that is and has been available in SSRS and paginated reports for years. I am not sure why there would be any more complexity of implementing it and making available in PBI visuals.

Amanda Rivera (SHE/HER)'s profile image Profile Picture

Ashish Kunhipura on 23 Mar 2023 16:31:27

RE: Add expand/collapse feature to column headers

Hello MS Team, Any further updates on the expand/collapse of column headers in matrix visual?

Amanda Rivera (SHE/HER)'s profile image Profile Picture

Mária Kvasnicová on 20 Mar 2023 15:39:42

RE: Add expand/collapse feature to column headers

It would be also nice to add this function to measures as columns, so that we can collapse measures that are not that important, but will be still available if needed for interpretation of data.

Amanda Rivera (SHE/HER)'s profile image Profile Picture

Kael Dowdy on 22 Feb 2023 18:38:34

RE: Add expand/collapse feature to column headers

Really love a similar feature in Excel. I have a very wide matrix visual in PBI and it'd be nice to collapse groups of them and let the user choose their own destiny so to speak.Wonder if this could be done using calculation groups or something... But would be nice to have feature built in directly in visual.

Amanda Rivera (SHE/HER)'s profile image Profile Picture

Ashish Dhone on 28 Jan 2023 21:41:51

RE: Add expand/collapse feature to column headers

test

Amanda Rivera (SHE/HER)'s profile image Profile Picture

Agustin Perez on 23 Dec 2022 08:34:48

RE: Add expand/collapse feature to column headers

This would be great to simplify the drill on that some users not understand

Amanda Rivera (SHE/HER)'s profile image Profile Picture

Jarrell Dunson on 21 Nov 2022 14:06:25

RE: Add expand/collapse feature to column headers

This is a standard feature with Qlik... has been for several years... can you please add this for Power BI?

Amanda Rivera (SHE/HER)'s profile image Profile Picture

Michel Attin on 13 Nov 2022 15:42:15

RE: Add expand/collapse feature to column headers

Please implement this functionality. I am working on migrating some excel reports to PBI. As users have this feature in excel, they need to see it in PBI also.

Amanda Rivera (SHE/HER)'s profile image Profile Picture

Jonathan Dufault on 08 Nov 2022 17:43:01

RE: Add expand/collapse feature to column headers

just a meta comment. it is extremely deflating having the "top idea" be an idea submitted almost four years ago with a bunch of comments and still "under review"maybe highlight some successes on the front page? unless you're going for the "don't even try"