Matrix: No option to expand collapse columns with +/- ??

[sasdfasdfsad]

Is there no way to show the +/- headers to expand or collapse column headers in a matrix in Power BI the same way you can for rows?

[sasdfasdfsad]

It's so infurating because 10 years later and it STILL can't do what a simple Excel Pivot Table can do... it just blows my mind.

[cengizhanarslan]

No, Power BI does not support +/- expand/collapse icons for column headers in a Matrix. This is by design, not a missing setting.

A practical workaround is described below:

• Matrix 1 → summary view

• Matrix 2 → detailed view

• Controlled by:

  • Buttons

  • Bookmarks

  • Page navigation

This avoids the expectation of column expandability entirely.

[krishnakanth240 · Accepted solution]

Hi @sasdfasdfsad 

No, does not support expand/collapse (+/–) for Matrix columns which is a limitation.
+/– buttons only work for 'Rows Headers' in Visual formatting.

[FBergamaschi]

Hi @sasdfasdfsad,

as far as I know, no.

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI