How can we improve Power BI?

Pivot tables and breakdown trees

The current version of Power BI visualsation framework does not support access to the previous levels in a drill-down. I.e. you only get access to the current level when rendering. That makes it very hard to develop visualizations such as pivot tables or breakdown trees. Make this possible and I would gladly submit a stable version of my Breakdown Trees :).

2,966 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

    fredrik.hedenstrom@acando.com shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    110 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Rad0mir commented  ·   ·  Flag as inappropriate

        NEW MATRIX PREVIEW is a GREAT JOB.
        However I have 2 comment on topic
        1. Drilling down is a super feature, but when I am down to nth level and suddenly change main Slicer filter (highest level) connected to NEW MATRIX PREVIEW it show nothing and i have to drill up several levels to get to numbers. I understand it depend on model and architecture of levels, but if there is option in interaction mode DRILL UP to HIGHEST LEVEL WHEN CHANGING SLICER it would be perfect.
        2) collumn drill down does not work with buttons only right click/ drill down/up

      • Anonymous commented  ·   ·  Flag as inappropriate

        Please add the functionality of a Pivot Table from Excel where I can place values on the rows OR the columns.

        Currently all measures must be on columns, so if I wanted to list Sales and profit and costs and hours, etc... by department and Month instead of having 12 month columns across the top, I get those 12 month columns and each of those measures repeated so my page becomes 12 x count of measures wide.

        Instead of just doing 12 months and then each measure listing under the row:

        I would rather see each Department and under each Department Sales, Profit, Costs, etc... so I can compare them left to right over the months columns.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Hi Amanda,
        Great job with the new matrix and table visuals.
        hope it reaches ga soon.
        Can you tell me if in the new visuals you plan to enable changing column caption ? if so do you have a time frame ?

        thanks

      • Aldo Medeiros commented  ·   ·  Flag as inappropriate

        In the nem matriz, we need to expande to next level, but just in on category.
        if you have 10 categorys, sometimes whold be great to just open one or two categories drill

      • JD commented  ·   ·  Flag as inappropriate

        While the stepped layout was big on the wish list, it seems that by using the Matrix Preview I've lost the ability to manually adjust those column widths. Since I had a MTD dashboard which summarizes daily quantity and duration, and default column headings are quite lengthy once you tack "Count of" or "Maximum of" prefix to the field. It leaves a view of only 4-5 days without scrolling to see the full MTD (not a desirable quality in a dashboard, BTW). Wish I had my adjustable column width back -OR- that it was possible to override the column header (with renaming the field, since it's used elsewhere and "#" would not be descriptive or accurate). Unfortunately, I'm back to the old Matrix with filtered rows until this is resolved.

      • Roberto commented  ·   ·  Flag as inappropriate

        Amazing! Could be better with possibility to change text dimension like original matrix

      • Mark Walter commented  ·   ·  Flag as inappropriate

        I LOVE the new matrix preview, a really big step for sure. Wondering if it will be possible to cross filter AND drill in on a second table? For example, I have a sales table on the left that allows me to filter a select customers sales. The table to the right does cross filters to show that customers sub products purchased. I now want to drill in to that second tables selected sub products and see the parts purchased by my selected customer. When I do so, the original customer table seems to loose the filter? Just a thought, i'm sure it's in the mix. Also, being able to determine what gets a sub total and what doesn't would be awesome! Thanks again for this awesome feature! We're already using it in a much asked for drill in report!

      • Anonymous commented  ·   ·  Flag as inappropriate

        New matrix looks great, but removing all of the column totals is a deal-breaker. So close, but back to waiting another month (or more).

      • Anonymous commented  ·   ·  Flag as inappropriate

        Great March 2017 updates, specifically the new matrix, getting closer to getting the decomposition tree ......

      • Anonymous commented  ·   ·  Flag as inappropriate

        Hi Amanda,

        great to hear that - i have been waiting for this improvment. Power BI is getting better and better.

      • Phil commented  ·   ·  Flag as inappropriate

        Alternatively, the "Export Data" option of the Matrix visual could include in the Excel document a pivot table which matches the Matrix visual, in addition to the underlying data table which it already provides. Then the user could double-click the pivot table cell to get a filtered list.

      • Phil commented  ·   ·  Flag as inappropriate

        For pivottable-like functionality, I'd like to be able to right-click or double-click (in Excel it's double-click) on a cell in the matrix and see the underlying data, or export that data to Excel similar to the "Export Data" option found when clicking the ellipsis in the top-right corner of a visual.

      • Simon commented  ·   ·  Flag as inappropriate

        This is one of reasons why I'm reluctant to switch from qliksense to Power BI. Please add this feature

      • Kyle Mitchell commented  ·   ·  Flag as inappropriate

        Please add pivot like expand & collapse buttons. I have seen the latest word wrap feature however the ability to word wrap all row headers & column headers (or values headers) would be awesome!
        This is a really great tool so far & obviously some further tweaking will make this immense. I have used other reporting platforms such as Qlikview & SAP Lumira however I think Power BI is a front runner purely down to current ability, potential & cost. Thanks!

      ← Previous 1 3 4 5 6

      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.