Skip to main content

Power BI

Under Review

Add expand/collapse feature to column headers

Vote (10341) 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 (169)
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

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

Martin Kratky on 22 Oct 2020 06:27:55

RE: Add expand/collapse feature to column headers

This feature is available in Acterys Matrix https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200000186?tab=Overview

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

Bruno Eduardo de Rossi on 17 Oct 2020 12:50:54

RE: Add expand/collapse feature to column headers

Look, it is the exceptional function this point to have a view within a table, we have countless possibilities of use, such as a company's cash flow, grouping sales periods of products and categories, that is, the possibilities will be absurd with that functionality.

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

Emma Haydon on 12 Oct 2020 09:36:17

RE: Add expand/collapse feature to column headers

To act as though Power BI is the future and not have equivalent functionality to Excel as the basic offering seems absolute madness to me!

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

Ross Robinson on 25 Sep 2020 03:10:45

RE: Add expand/collapse feature to column headers

This would be a big help. I come from a SAP BW/BI background and we take for granted the ability to be able to organise measures using expand/collapse toggles. I was surprised this was not available by default in Power BI.

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

Ralf Krahnert on 23 Sep 2020 08:39:11

RE: Add expand/collapse feature to column headers

Would be very helpful!

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

trum cuoi phan thiet on 08 Sep 2020 15:45:47

RE: Add expand/collapse feature to column headers

nbnhb

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

trum cuoi phan thiet on 08 Sep 2020 15:39:10

RE: Add expand/collapse feature to column headers

hb