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

Power BI User on 05 Jul 2020 22:31:50

RE: Matrix +/- Collapse/ Expand Buttons

Needed now.......

Sean's profile image Profile Picture

Power BI User on 05 Jul 2020 22:31:46

RE: Matrix +/- Collapse/ Expand Buttons

A must to add ASAP!

Sean's profile image Profile Picture

Power BI User on 05 Jul 2020 22:31:43

RE: Matrix +/- Collapse/ Expand Buttons

'+1 for this.

Sean's profile image Profile Picture

Power BI User 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

Scott Kennedy on 05 Jul 2020 22:31:18

RE: Matrix +/- Collapse/ Expand Buttons

What is the update on this?

Sean's profile image Profile Picture

Power BI User 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

Peter Grueterich 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

Borut 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

Ken 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

Ken on 05 Jul 2020 22:30:31

RE: Matrix +/- Collapse/ Expand Buttons

What's the new update status?