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

269d0b49 a15e-4ae0-8b60-ef1e201c4174 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

79298be4 0051-45ee-811a-d7f09a88669a 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

662de51e ab87-4d84-858a-34730d7084f7 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

0396f975 b224-44b0-b951-39f6fc5f47a8 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

36244394 7b1e-413b-a802-7049af5bd37f 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

b70beb9e bb5f-4572-9b35-bd4a59a1dfe0 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

299aaa60 183a-4388-8334-9aa0c9c91eb9 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

a611d563 5c72-4c5d-8d0f-91987a9cdc21 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

54c42f6b 4cd8-4a0a-85ff-0c5387fd2676 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

690c60b5 c879-4fb6-8f4a-98462e3495ad 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!!