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,402 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 →

    201 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        @gv, this is for selective drilldown. In PBI you cannot selectively expand/collapse nodes, which is a big problem and really inefficient on larger models.

      • gv commented  ·   ·  Flag as inappropriate

        Is this idea still relevant given that there is now this powerful PBI feature to drill down both vertically and horizontally wherever you like in the matrix visual?

      • Bas commented  ·   ·  Flag as inappropriate

        This is now under review for almost a year, @Microsoft what is the status here?

      • Anastasia commented  ·   ·  Flag as inappropriate

        Some tables are rather long, very nice feature- less scrolling! We would need exactly this in order to hide columns for specific years and leave only those necessary for comparison.

      • Amir Netz commented  ·   ·  Flag as inappropriate

        While it may seem like a simple feature, to implement +/- in a way that will perform well and be scalable we'll need to enhance some deep architectural foundations in the Power BI visuals framework. The enhancements will allow a visual to send multiple different queries to the BI model and "stitch" them together to a single graphical representation. This will allow a visual to create "a-symmetrical" views with varying degrees of detail depth.

        This architectural enhancement is a significant effort and we will start it this sprint with the intent of delivering this summer.

        +/- on the matrix visual will be the first implementation of that capability and will hope to deliver it this summer.

        Once the architectural enhancement is completed it will open the door to a whole new class of visuals, including the breakdown trees.

      • Martin commented  ·   ·  Flag as inappropriate

        Just as an update to comments re Agility Planning Matrix Light: To support the community we have made a light version that includes this feature of www.agilityplanning.com available free of charge: http://www.managility.co/agility-planning-matrix-light-visual/ . We would love to incorporate more features but can only do this in custom projects or if users are willing to sponsor features. Please contact us.

      • kl commented  ·   ·  Flag as inappropriate

        The Agility planning matrix is better than nothing, but the lack of formatting options for the different levels is frustrating. This is like Excel pivot 101 stuff.

      • Martin Kratky commented  ·   ·  Flag as inappropriate

        To the anonymous user after this post: just register on the website then the download link on the page will be active.

      ← Previous 1 3 4 5 10 11

      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.