Skip to main content
Microsoft Idea

Power BI

Under Review

Add expand/collapse feature to column headers

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

Paul Ranschaert on 06 Jul 2020 00:13:01

RE: Add expand/collapse feature to column headers

Yes would be very helpfull to add this. I have In the month, year to date measures and 12 month rolling averages. For the YTD and 12 MRA you don't want to see every month but only the last month.

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

Power BI Ideas Admin on 06 Jul 2020 00:11:23

RE: Add expand/collapse feature to column headers

this would real help me

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

Ross Power BI User on 06 Jul 2020 00:11:22

RE: Add expand/collapse feature to column headers

This is a critical requirement for many reports. please implement

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

Cynthia on 06 Jul 2020 00:10:41

RE: Add expand/collapse feature to column headers

Yes, please! Usually I face a matrix were in rows I have employees names and in columns the year/month/day...

I tried changing the order, but some offices has >30 employees so you can imagine the visual mess of searching them in the columns. In the same way, what I'm doing now it's to having employees in the rows and dates in the columns, but then when you expand to next level up to the day, now the visual displays all days (segmented in months) YTD, imagine what will happen to my matrix in a few more months! and if you are thinking about the filters, I have them, but as this matrix is part of a report showing other features, sometimes final users do not like to use the filters in order to see 'everything at a glance' ...

thank you

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

Power BI User on 06 Jul 2020 00:09:02

RE: Add expand/collapse feature to column headers

Absolutely required

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

Power BI User on 06 Jul 2020 00:08:51

RE: Add expand/collapse feature to column headers

Agree with comment and it is realy necessary .....It would be great if column headers in the matrix can be expanded/collapsed the same way as for rows. Our finance users would like to show Year numbers in a column with ability to drill down to quarter, month level columns.

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

Ivan Georgiev on 06 Jul 2020 00:07:53

RE: Add expand/collapse feature to column headers

It would be awesome to have this feature!

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

Umar Ayub on 06 Jul 2020 00:07:44

RE: Add expand/collapse feature to column headers

Definitely need the + buttons on the columns really useful

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

Julia Fang on 06 Jul 2020 00:07:43

RE: Add expand/collapse feature to column headers

It would be great if column headers in the matrix can be expanded/collapsed the same way as for rows. Our finance users would like to show Year numbers in a column with ability to drill down to quarter, month level columns.

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

Rossitza Slavova on 06 Jul 2020 00:07:37

RE: Add expand/collapse feature to column headers

It is very important feature. I would like to be able to collapse and expand columns. For example: I would like to be able to show monthly values of a measure for previous months and see weekly values only for current month. Also conditional formatting should be applied to totals as well which is not the case currently. Can't you do it similar to excel and reporting services?