Skip to main content
Microsoft Idea

Power BI

Under Review

Add expand/collapse feature to column headers

Vote (10213) 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 (166)
Amanda Rivera (SHE/HER)'s profile image Profile Picture

Martin Kanarbik on 24 May 2021 10:05:45

RE: Add expand/collapse feature to column headers

Hi,

I am really hoping to see this function in the near future. I think most agree that basics functions like these should be priority, these other fancy updates can wait a little.

MS you can do it!

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

Juan Carlos Araya on 16 May 2021 15:15:39

RE: Add expand/collapse feature to column headers

Hi Microsoft, recently I was asked this as a minimum requirements to one of my reports...
I had to to tell Management this wasn't possible.. this is one of the most up vote ideas... Any update on this idea?

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

Mohammed SUHEL on 27 Apr 2021 08:50:03

RE: Add expand/collapse feature to column headers

Any update, how much time would it take Even Microsoft require Years to get in Products.?

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

Kyle Rudnik on 26 Apr 2021 14:23:27

RE: Add expand/collapse feature to column headers

Any update on the status? How long does an idea typically take to from under review to planned?

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

Thuy Duong Le on 26 Mar 2021 15:50:42

RE: Add expand/collapse feature to column headers

Please add this feature! It does not make sense that PowerBI does not have simple features that are available in Excel Pivot tables.

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

Tore Senneseth on 29 Jan 2021 13:55:03

RE: Add expand/collapse feature to column headers

This feature is available in version 4 of the Financial Reporting Matrix custom visual. You can watch a demo video here: https://www.youtube.com/watch?v=lfX0O1jMOMo

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

Ruth ballinger on 29 Jan 2021 05:48:47

RE: Add expand/collapse feature to column headers

And make the plus/minus buttons a default not having to add every time?

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

Josef Künzli on 30 Dec 2020 10:48:32

RE: Add expand/collapse feature to column headers

In General for the Matrix visual, all functionalities for the Rows should also be available for the Columns in the same way. For example, Sort is only available for Rows and Values, not for Columns. But this is much needed for Finance Reporting. It could easily be included in the "More Options" menu within the visual. That could be a quick win to implement

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

Rasmus Kaas on 17 Dec 2020 09:29:46

RE: Add expand/collapse feature to column headers

I have been working as a Power BI developer/consultant from the start, and every month since then I have been scrolling through the list of new updates, looking for this feature.

I cannot count how many customers throughout those years, I have been trying to tell how great Power BI is, and then explain to them why this feature is not available. It is hard to implement, is the best answer I have been able to give, then they look at me and say, But it has been in Excel since the dawn of time...

I have not given up yet.

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

sohail ansari on 21 Nov 2020 12:17:07

RE: Add expand/collapse feature to column headers

4+ years and it was Amanda your own employee, still waiting for it. Great