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,836 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Sean shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    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

    238 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • 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.

      • Anonymous commented  ·   ·  Flag as inappropriate

        We see the Matrix +/- Collapse/ Expand Buttons with latest desktop release, but it's for rows only. Anything being worked on make it available for column headers too?

      • Joost.Groothuizen commented  ·   ·  Flag as inappropriate

        Same here... we discussed a case on Monday. Weeks in the columns and the possibility to +(show) the single days of only the last week.

        Expected this would be possible...

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