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

c1d64842 f210-4e95-80ef-8e133c5488b3 on 05 Jul 2020 23:08:25

RE: Matrix +/- Collapse/ Expand Buttons

To the anonymous user after this post: just register on the website then the download link on the page will be active.

Sean's profile image Profile Picture

f59f2225 5262-463e-a846-a230de1764a5 on 05 Jul 2020 23:08:22

RE: Matrix +/- Collapse/ Expand Buttons

Hello Martin, can you please tell me how to download. I registered with Agility Planning but not finding inside any thing downloads or download links.

Sean's profile image Profile Picture

b18ef208 41a6-484d-8dee-adf59a3e9d5f on 05 Jul 2020 23:07:21

RE: Matrix +/- Collapse/ Expand Buttons

To be able to rename Subtotal and Total i.e Total Revenue etc.

Sean's profile image Profile Picture

740fdd37 1e3e-47f1-a79a-dda8beff5a6d on 05 Jul 2020 23:06:49

RE: Matrix +/- Collapse/ Expand Buttons

Still needed. PLEASE implement this change. Thanks.

Sean's profile image Profile Picture

a8768573 df5e-49fe-b3d7-48cda59f7358 on 05 Jul 2020 23:06:34

RE: Matrix +/- Collapse/ Expand Buttons

Hopefully this feature will be release soon!

Sean's profile image Profile Picture

a92640e2 9aa9-4bbe-ac79-fd46e98c9402 on 05 Jul 2020 23:06:05

RE: Matrix +/- Collapse/ Expand Buttons

Please add this feature to both Table and Matrix. Similar to Excel column groupings by columns.

In Excel the feature is "Group, Ungroup". It would also be helpful to be able to create groups within a group (subgroups). Again, match Excel column grouping functionalities.

Sean's profile image Profile Picture

deb1dd20 d4be-44bf-8e89-ab263081f452 on 05 Jul 2020 23:05:52

RE: Matrix +/- Collapse/ Expand Buttons

Hey is there any update on this

Sean's profile image Profile Picture

881e603e 574d-4626-8ba7-010e2ce00a7f on 05 Jul 2020 23:05:46

RE: Matrix +/- Collapse/ Expand Buttons

A slicer to select the level would be enough for that. Please inform us about the timeline to include this feature. I hope soon we can see this "simple" possibilities (simple base on how easy it is in Excel).

Sean's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:04:56

RE: Matrix +/- Collapse/ Expand Buttons

One important feature in this idea is the expanding of a level with just one item below and be able to hide this (because the subtotal and the one item below have the exact same values)

Sean's profile image Profile Picture

e628c294 7267-469b-981c-a4731a420e9c on 05 Jul 2020 23:04:48

RE: Matrix +/- Collapse/ Expand Buttons

We are in need of this ASAP as well. When is this planned for release???