How can we improve Power BI?

Matrix +/- Collapse/ Expand Buttons

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!

3,792 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Sean shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
completed  ·  AdminAmanda Cofsky (Program Manager, Microsoft Power BI) responded  · 

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

239 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • V commented  ·   ·  Flag as inappropriate

    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).

  • Hannes K commented  ·   ·  Flag as inappropriate

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

  • Kyle Ward commented  ·   ·  Flag as inappropriate

    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?

  • Ben Sanders commented  ·   ·  Flag as inappropriate

    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.

  • Anonymous commented  ·   ·  Flag as inappropriate

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

  • Arvind Singh commented  ·   ·  Flag as inappropriate

    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? :(

  • Denise commented  ·   ·  Flag as inappropriate

    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.

  • Joke commented  ·   ·  Flag as inappropriate

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

  • Rebecca H commented  ·   ·  Flag as inappropriate

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

  • Anonymous commented  ·   ·  Flag as inappropriate

    +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.

  • Sara Ricketts commented  ·   ·  Flag as inappropriate

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

  • Cogahson Trioman commented  ·   ·  Flag as inappropriate

    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.

  • Michael Ring commented  ·   ·  Flag as inappropriate

    Disappointing that this is not available for MD. Tableau seems to handle this functionality very well with MD so you would expect PowerBI, another Microsoft product, to provide the same functionality.

← Previous 1 3 4 5 11 12

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.