Skip to main content

Power BI

Completed

Matrix +/- Collapse/ Expand Buttons

Vote (3762) Share
Sean's profile image

Sean on 07 Aug 2015 03:38:36

Please add Collapse/Expand buttons in the Matrix Visualizations. Otherwise when all fields are expanded by default the user would have to scroll a lot to find what they are looking for. I could add a slicer to take user to the data they are looking for but then the rest of the data in the matrix disappears and more specifically the overall totals change!Expand/Collapse buttons would keep the overall totals as intended and totals for other fields while allowing the user to only expand the field they are interested in. Also ability to do conditional formatting for a specific field in the matrix would be nice. Thanks!

Administrator on 17 Nov 2018 02:34:25

With our November update of Power BI Desktop, you can now expand/collapse matrix row headers. You can read more on our blog: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/#expandCollapse A few people were asking about column headers. As some of the work involved for column headers is different than row headers, we want to understand how many users specifically need/want column header support as well. If you need column header support, please vote on this idea that I added to UserVoice: https://ideas.powerbi.com/forums/265200/suggestions/36038050

Comments (234)
Sean's profile image Profile Picture

Budi Kristianto on 05 Jul 2020 23:56:21

RE: Matrix +/- Collapse/ Expand Buttons

When there is non-numerical data (e.g. text or string) in one of the columns and the values vary between rows what values does it display when the row header is collapsed? At first glance it seems to pick the MIN value of the strings / dates. On the other hand numeric columns are usually fine to be totaled when collapsed. It would be useful for us to have an option to not aggregate the string and date columns when collapsing the row header at least.

Sean's profile image Profile Picture

Tomes Molokomme on 05 Jul 2020 23:56:04

RE: Matrix +/- Collapse/ Expand Buttons

Matrix +/- Collapse/ Expand Buttons not available on Direct Query it only works for imports.
Visuals does not show percentages in Direct Query, They only show decimals

Sean's profile image Profile Picture

Douglas on 05 Jul 2020 23:49:44

RE: Matrix +/- Collapse/ Expand Buttons

How to export a Matrix keeping the pivoted columns ?

Sean's profile image Profile Picture

Jyri Mustola on 05 Jul 2020 23:46:19

RE: Matrix +/- Collapse/ Expand Buttons

Will support be added for SSAS MD?

Sean's profile image Profile Picture

Robin Chacko on 05 Jul 2020 23:43:04

RE: Matrix +/- Collapse/ Expand Buttons

Thanks. Matrix is a great tool for report presentation

Sean's profile image Profile Picture

V on 05 Jul 2020 23:41:20

RE: Matrix +/- Collapse/ Expand Buttons

For everyone who needs pivot tables with expand/collapse (both for rows and columns) that works with direct connection DB sources: take a look to SeekTable.com (this is free web-based tool).

Sean's profile image Profile Picture

Erkka Sarnola on 05 Jul 2020 23:39:42

RE: Matrix +/- Collapse/ Expand Buttons

Should be also in columns.

Sean's profile image Profile Picture

Hannes K on 05 Jul 2020 23:36:52

RE: Matrix +/- Collapse/ Expand Buttons

It seems that the +/- function is not available with Live Connections from a cube. Will there be any updates?

Sean's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:36:43

RE: Matrix +/- Collapse/ Expand Buttons

The +/- buttons do not display correctly in Internet Explorer. Many of my users are not adept in their computer abilities, so converting their browser preference is not a simple task. Can we fix the +/- buttons so that Internet Explorer is compatible for them?

Sean's profile image Profile Picture

Ben Sanders on 05 Jul 2020 23:36:42

RE: Matrix +/- Collapse/ Expand Buttons

More importantly we need to be able to keep the column headers when collapsing a matrix (similar to excel) otherwise large swaths of the report page just look blank which is not great from a visual presentation perspective.