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)
RE: Pivot tables and breakdown trees
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
RE: Pivot tables and breakdown trees
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.
RE: Pivot tables and breakdown trees
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
RE: Pivot tables and breakdown trees
How about letting us set a default initial drill level?
RE: Pivot tables and breakdown trees
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
RE: Pivot tables and breakdown trees
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.
RE: Pivot tables and breakdown trees
I agree, having to scroll across is not something my audience is willing to do
RE: Pivot tables and breakdown trees
Amazing! Could be better with possibility to change text dimension like original matrix
RE: Pivot tables and breakdown trees
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!
RE: Pivot tables and breakdown trees
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).