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

3ccb8f18 9df0-4d6a-83b6-b3a5d1c682e2 on 05 Jul 2020 22:31:50

RE: Matrix +/- Collapse/ Expand Buttons

Needed now.......

Sean's profile image Profile Picture

c580b079 1f58-449d-a980-6313ae7ce7a0 on 05 Jul 2020 22:31:46

RE: Matrix +/- Collapse/ Expand Buttons

A must to add ASAP!

Sean's profile image Profile Picture

17dc92fe 604d-43c2-9c48-b8c20b24fa13 on 05 Jul 2020 22:31:43

RE: Matrix +/- Collapse/ Expand Buttons

'+1 for this.

Sean's profile image Profile Picture

5fe2abd9 ffbe-4075-b432-6a77a3c5fb58 on 05 Jul 2020 22:31:37

RE: Matrix +/- Collapse/ Expand Buttons

Since May 12 'under review' by MS. Please let users know how soon MS plans this feature for release.

Sean's profile image Profile Picture

cf433bcc 5bba-445f-8c05-ebf1011ea773 on 05 Jul 2020 22:31:18

RE: Matrix +/- Collapse/ Expand Buttons

What is the update on this?

Sean's profile image Profile Picture

318099c5 7ac9-45da-bf60-5dcf48ee04ba on 05 Jul 2020 22:31:17

RE: Matrix +/- Collapse/ Expand Buttons

Should be possible. You can do this in pivot but not in Power BI. Easier to visualize P&L sheet when you can add drill down.

Sean's profile image Profile Picture

35544a6e 7b38-4653-9e0e-b4bcc31d437b on 05 Jul 2020 22:30:49

RE: Matrix +/- Collapse/ Expand Buttons

This is badly needed. We need to be able to drill down the matrix and table visuals with expand/collapse buttons or double click on row to drill down/up to next level. This is pretty much standard on table and matrix reports on other apps. Please let us know when this will be coming. We did not hear any news since your post from May 12th, Filip. Thank you !!

Sean's profile image Profile Picture

50edaf24 0bb3-4eae-864f-fc97f23ee413 on 05 Jul 2020 22:30:46

RE: Matrix +/- Collapse/ Expand Buttons

This is something that we really need it. We need to drill down the matrix with expand/collapse buttons. Can you give us any information regarding this?

Sean's profile image Profile Picture

1463699d da1b-4569-a71d-f4ed129c4d09 on 05 Jul 2020 22:30:31

RE: Matrix +/- Collapse/ Expand Buttons

Yes Power BI should have this. This was in Power View I am just not following how MS is missing how important such little things are that makes a company choose another tool because of such little things. Also why would power BI be a step backwards in any aspect from power View.

Sean's profile image Profile Picture

1463699d da1b-4569-a71d-f4ed129c4d09 on 05 Jul 2020 22:30:31

RE: Matrix +/- Collapse/ Expand Buttons

What's the new update status?