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 :).
We released a preview of a new matrix visual with today Power BI Desktop release. This new matrix can be used as a source of cross-highlighting, has a stepped layout, can be drilled in to /out of hierarchies, and has performance updates.
You can read all about it in our blog post: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-feature-summary/#matrix
During the preview we will be adding even more new features, so keep watch each month for more improvements and let us know in comments what else you’d like to see.
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
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.
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 ?
How about letting us set a default initial drill level?
Aldo Medeiros commented
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
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.
Mr BlueSky commented
I agree, having to scroll across is not something my audience is willing to do
Amazing! Could be better with possibility to change text dimension like original matrix
Mark Walter commented
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!
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).
Ignas Špokas commented
I would also agree that text wrap in columns would be enabled. It would be very useful feature.
Great March 2017 updates, specifically the new matrix, getting closer to getting the decomposition tree ......
Demétrio Silva commented
Same here, great news which I have been waiting for for some time.....
great to hear that - i have been waiting for this improvment. Power BI is getting better and better.
Shintaro TAKEMURA commented
Sorry for my typo. Please support hierarchical column headers like old matrix for new matrix .
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.
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.
Ian James commented
Definitely needed, this is a current request from a client
This is one of reasons why I'm reluctant to switch from qliksense to Power BI. Please add this feature