Matrix +/- Collapse/ Expand Buttons
Please add Collapse/Expand buttons in the Matrix Visualizations. Otherwise when all fields are expanded by default the user would have to scroll a lot to find what they are looking for. I could add a slicer to take user to the data they are looking for but then the rest of the data in the matrix disappears and more specifically the overall totals change!Expand/Collapse buttons would keep the overall totals as intended and totals for other fields while allowing the user to only expand the field they are interested in. Also ability to do conditional formatting for a specific field in the matrix would be nice. Thanks!
Looks like Amanda’s link didn’t work so I wanted to update again. Here’s our documentation on the new preview:
There are a few highly requested features that we know are missing (resizing columns, sorting etc.) and they’re outlined at the bottom of that document .They’ll come in future releases!
You’ll also see a link right at the bottom of that page to a survey where you can gives us your feedback on what we should prioritize on top of this preview.
and please do keep commenting here – we read everything even if we can’t reply to them.
Thanks for the feedback!
Sort on Total is not Working.
Its is highly recommended to add " +/- Collapse/ Expand Buttons", because by viewing the report itself its easy to know the drill down facility is there. Other wise the person don't have the technical stuff on this, in the production environment, how he came to know for seeing drill down data, until he know from other technical person. SSRS reporting and all other competitor tools has this "+/- Collapse/ Expand Buttons", then why Microsoft till did not introduced this feature. Every month Microsoft has introducing new user friendly features.. then why this feature has not been added till now, at least this month June updates we expect to see tis one..
Faiçal KHAN commented
When will we have the "Grand Rows Total" without Sub-totals into the Matrix Visualization?
Congratulations for your great tool, improving every day!
This capability has been around since PivotTables started eons ago. I can't believe it still is not there for both tables and matrices in Power BI.
Does anyone else have an issue with the page resetting once you scroll down on the matrix preview?
Jose Miguel Rojas P commented
For sure this will be useful.
Robin Clement commented
I'm missing the sorting function in the Matrix Preview visual! Like SSRS, you should get an additional option in Column Formatting where you can set sorting on the Group rows or Detail rows.
Todd Chittenden commented
With the new Matrix visual, introduced in the March 2017 update, there is still some basic cross-highlight functionality that is missing, making for MISLEADING reports!
If you set up a New Matrix with two level on the Rows, then add your Value, and also add a Card visual to the report page and in that display the same Value as utilized by the New Matrix.
Now, browse the matrix by clicking on a member of the top level. Notice that the Card gets filtered.
Now turn on Drill-Down for the Matrix and click on a top level again. Notice that the Card does NOT get filtered!!!
Why can't I have functionality of BOTH Drill-Down AND CROSS-FILTERING from the matrix?!?
BTW, this same limitation exists for bar, column and other chart types that support drill-down.
John O. commented
The matrix tables in Power BI are absolute garbage. I do not understand why it is so difficult for the same company that created Pivot Tables for Excel cannot get this right for Power BI. Why cant I create a matrix that has some hierarchies expanded and some collapsed? Why cant I create a calculated column right in the Matrix instead of having to create a measure in the raw data? Why can't I make matrix column title aliases instead of it saying 'sum of xxx' or 'average of xxx'? This list goes on. I would love to better utilize this feature and Power BI in general, but until this visualization can even do the bare basics that excel can do it is useless.
Todd Chittenden commented
New Matrix looks good, for the most part, but what happened to the Totals at the bottom? Without that it's pretty much useless.
Also, it would be nice to have a way to include additional non-measure fields that are also NOT levels of breakdown.
Example: Suppose you wanted to have a matrix of people's Names on the rows, but also wanted to display their City of residence next to the name
You would want the layout to look like this:
Bob | El Paso | $$ | $$
Jim | Detroit | $$ | $$
What you DON'T want is this:
El Paso | $$ | $$
Bob total | $$ | $$
Detroit | $$ | $$
Total Jim | $$ | $$
In Analysis Services it was a non-aggregated dimension property. In Excel Pivot tables there was a way to format your pivot so it resembled the desired layout.
Any chance of adding that capability?
I forgot, please add like in Excel the KPI possibility, with font formating (arrows up and down with color for instance)
This greatly helped the using of PowerBI. Thank you ! I cannot understand other guys criticising this new possibility..
While Exploring, it should also have the possibility to filter other Visualisations too.
Waiting for future releases. Already took the Survey ;-)
Adam Kruzel commented
Really need the +/- to individually collapse and expand groups. I think the more like Excel you make this, the easier it is for users to adopt especially when the functionality in Excel is better than what's in Power BI.
SUBHOLINA DEB commented
NEED COLOR FIELD FEATURE AS IN TABULAE..
SUBHOLINA DEB commented
PLEASE ADD THE PARAMETERS FEATURE IN POWER BI,IT IS HARDLY NEEDED..
Kristen Pugi commented
Very good long long long waited start.
Like: good speed; cross higlighting in all possible ways; drilldown options. It immedialtely opened financial reporting options in even better manner than in Excel due cross-highlighting capabilities in PBI.
Waiting to be added: +/- drilldown like in Excel; formatting; and specially conditional formatting using ohter measures; sorting
Ok It's a start.
Three issues I have:
1. I can't adjust the column widths manually
2. URLs when used as Values are not clickable links despite their column being categorised as Web URL. They are clickable when used in a table and in the new matrix when used as Rows *but only when* drilled down to their level.
3. Columns seem to be formatted as centre aligned - I can't find a formatting tool to change that.
I spent an hour playing around with the matrix getting to understand how it works, I think it shows promise... I agree with people's comments about the +/- buttons being a preference - do we really need to teach our users a different interface?
When you drill down and then want to go back to the parent report it brings you back to the top of the matrix, you completely lose track of where you were in the report. This really should be fixed and I'm not sure why this wasn't done as simple +/- toggles.
Please send an update when Grand Total is working. Thanks!
That's pretty nice - thanks PBI devs.