Skip to main content
Microsoft Idea

Power BI

Under Review

Add expand/collapse feature to column headers

Vote (10214) 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

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?

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

khan150 on 06 Jul 2020 00:07:24

RE: Add expand/collapse feature to column headers

still waiting.

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

Power BI Ideas Admin on 06 Jul 2020 00:07:14

RE: Add expand/collapse feature to column headers

really need this feature to hide/collapse rows

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

makcim sz on 06 Jul 2020 00:06:51

RE: Add expand/collapse feature to column headers

how come I can´t hide/collapse row headers? there's not even one custom visualization to supply this feature. Very annoying having to repeat headers in a series of matrices

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

Power BI Ideas Admin on 06 Jul 2020 00:06:38

RE: Add expand/collapse feature to column headers

'+1

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

Power BI User on 06 Jul 2020 00:06:31

RE: Add expand/collapse feature to column headers

Need this feature to even have the same functionality as SSRS