Skip to main content

Power BI

Completed

Pivot tables and breakdown trees

Vote (2916) Share
fredrik.hedenstrom@acando.com's profile image

fredrik.hedenstrom@acando.com on 28 Aug 2016 16:23:48

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

Administrator on 06 Sep 2017 04:02:09

Hi everyone. We've made the new matrix/table generally available so I'm closing this idea. There are still some features that we're considering and you can go add your votes to help prioritize those too: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9207006-matrix-collapse-expand-buttons https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17339728-more-flexible-conditional-formatting-in-tables-and https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13808061-matrix-sort-columns-by-value https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9508416-formatting-of-text-in-grid-and-matrix https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19124698-vertical-column-labels-in-table-and-matrix

Comments (109)
fredrik.hedenstrom@acando.com's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 22:29:24

RE: Pivot tables and breakdown trees

Great Looking forward to use this visuals back.

fredrik.hedenstrom@acando.com's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 22:28:57

RE: Pivot tables and breakdown trees

'+3 votes

fredrik.hedenstrom@acando.com's profile image Profile Picture

chandra on 05 Jul 2020 22:28:56

RE: Pivot tables and breakdown trees

Must have

fredrik.hedenstrom@acando.com's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 22:28:55

RE: Pivot tables and breakdown trees

My 100 Votes for it :)

fredrik.hedenstrom@acando.com's profile image Profile Picture

Giampaolo Pitzalis on 05 Jul 2020 22:28:44

RE: Pivot tables and breakdown trees

Very often requested.

fredrik.hedenstrom@acando.com's profile image Profile Picture

Power BI User on 05 Jul 2020 22:25:42

RE: Pivot tables and breakdown trees

Yes! I need a multi-variable table/matrix to function like a slicer, but be dynamic based on the other visuals.

fredrik.hedenstrom@acando.com's profile image Profile Picture

Daniel on 05 Jul 2020 22:23:14

RE: Pivot tables and breakdown trees

What about when you're using a Matrix, where you could select a row, column, or cell and have it display different views of the same thing.

fredrik.hedenstrom@acando.com's profile image Profile Picture

David Botz on 05 Jul 2020 22:22:25

RE: Pivot tables and breakdown trees

This is just intuitive for users. When a table is displayed then want it to filter the page by clicking a row. Make it optional though.

fredrik.hedenstrom@acando.com's profile image Profile Picture

Power BI User on 05 Jul 2020 22:22:23

RE: Pivot tables and breakdown trees

Is it possible to have a pivot table visual, same/similar to the pivot table we have in Excel that we could use as a visualization on our report(s)

fredrik.hedenstrom@acando.com's profile image Profile Picture

Power BI User on 05 Jul 2020 22:21:58

RE: Pivot tables and breakdown trees

When have Matrix or table allow click one or more elements of that table and then works like filtering the others visualizations.