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

Rob on 05 Jul 2020 22:40:57

RE: Pivot tables and breakdown trees

This would be great

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

Power BI User on 05 Jul 2020 22:40:28

RE: Pivot tables and breakdown trees

Wrapping for table headers is supported, but I do not see an option to wrap data field values in tables. Much needed, reports with individual scrollbars for each field does not look good!

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

Power BI User on 05 Jul 2020 22:39:46

RE: Pivot tables and breakdown trees

Agreed...this is currently a very limiting oversight. Notes from our project billing module are not easily seen by our project management teams because you can not wrap text within the dashboards

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

Trevor Curran on 05 Jul 2020 22:39:08

RE: Pivot tables and breakdown trees

you should be able to filter by records on a table. for example if you are looking at a table with various brands and want to isolate then all you would need to do is click the brand on the table. this functionality could be controlled via the roller brush settings.

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

Wesley on 05 Jul 2020 22:39:07

RE: Pivot tables and breakdown trees

Please add a option to format completely the column header. Justify, centralize, bold, italic... all those format option that can make a prettier dashboard.

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

Power BI User on 05 Jul 2020 22:39:07

RE: Pivot tables and breakdown trees

Yes - a very needed feature. Additionally, allow us to specify if the "overflow" should wrap, thus taking up more vertical space, or be sized smaller so that it can fit in the space allocated.

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

Brent Benson on 05 Jul 2020 22:38:24

RE: Pivot tables and breakdown trees

I would like the ability to turn text wrapping on for a standard table or matrix

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

Ivan Tamburic on 05 Jul 2020 22:37:11

RE: Pivot tables and breakdown trees

We also need drill-down to detailed data from an aggregated report...

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

sanjeeb.pahadi on 05 Jul 2020 22:35:23

RE: Pivot tables and breakdown trees

This would really helpful and time saver. I am just using a link as reference where age and region are graphically represented. Hope this would help.

https://www.dataz.io/display/Public/2013/09/16/How+to+Create+a+Small+Multiple+Masterpiece+in+Tableau

Thanks

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

Miguel Gallardo on 05 Jul 2020 22:35:15

RE: Pivot tables and breakdown trees

This would be an amazing improvement!

I hope you can release it soon!!