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 23:36:41

RE: Matrix +/- Collapse/ Expand Buttons

Now that we can now expand and collapse like pivot tables, can we control at what levels sub-totaling is calculated

Sean's profile image Profile Picture

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

RE: Matrix +/- Collapse/ Expand Buttons

Arvind Singh How about in Edge ? I don't think MS update IE anymore

Sean's profile image Profile Picture

Arvind Singh on 05 Jul 2020 23:36:28

RE: Matrix +/- Collapse/ Expand Buttons

It doesn't work as expected in IE. However in Chrome it works and look great. Please suggest being Microsoft tool it should work in IE first? :(

Sean's profile image Profile Picture

Denise Cook on 05 Jul 2020 23:36:17

RE: Matrix +/- Collapse/ Expand Buttons

I experienced the same issue where once I published a report using a matrix visual with the +/- icons looking terrible. Turns out I only experienced this when I was using Internet Explorer. In Edge & Chrome it looked great and worked as expected.

Sean's profile image Profile Picture

Joke Joke on 05 Jul 2020 23:36:16

RE: Matrix +/- Collapse/ Expand Buttons

Why is this not available for multidimensional models?? Unbelievable.

Sean's profile image Profile Picture

Rebecca H on 05 Jul 2020 23:36:02

RE: Matrix +/- Collapse/ Expand Buttons

The excitement of seeing this feature released was then followed by great disappointment finding out it is not supported for multidimensional models. Gutted!

Sean's profile image Profile Picture

Power BI User on 05 Jul 2020 23:36:01

RE: Matrix +/- Collapse/ Expand Buttons

'+1
here is a bug in expand collapse matrix when using conditional formatting. When i expand the field, the conditional formatting not applied in header field, but only applied in child field.

Sean's profile image Profile Picture

Sara Ricketts on 05 Jul 2020 23:35:43

RE: Matrix +/- Collapse/ Expand Buttons

Has anybody published a report using this visual with the +/- on? Looks like garbage - unusable. Can't see the plus symbols

Sean's profile image Profile Picture

Power BI User on 05 Jul 2020 23:35:39

RE: Matrix +/- Collapse/ Expand Buttons

So sad it's not available for MD.

Sean's profile image Profile Picture

Cogahson Trioman on 05 Jul 2020 23:35:37

RE: Matrix +/- Collapse/ Expand Buttons

there is a bug in expand collapse matrix when using conditional formatting. When i expand the field, the conditional formatting not applied in header field, but only applied in child field.