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!
With our November update of Power BI Desktop, you can now expand/collapse matrix row headers. You can read more on our blog: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/#expandCollapse
A few people were asking about column headers. As some of the work involved for column headers is different than row headers, we want to understand how many users specifically need/want column header support as well. If you need column header support, please vote on this idea that I added to UserVoice: https://ideas.powerbi.com/forums/265200/suggestions/36038050
Michael Ring commented
Disappointing that this is not available for MD. Tableau seems to handle this functionality very well with MD so you would expect PowerBI, another Microsoft product, to provide the same functionality.
GREAT GREAT improvement! Thanks Amanda.
Robert Duyvesteijn commented
Tried it today, and it works great! Thx
Same here... we discussed a case on Monday. Weeks in the columns and the possibility to +(show) the single days of only the last week.
Expected this would be possible...
Andreas S. commented
I also need this for column headers as well - please
Great job but Need this for column headers as well!
Need this for column headers as well.
My excitement got crush today that this feature is not supported for multidimensional models. This a long awaited feature, especially for Excel fans. Now my customers are totally disapointed with the limitation.
When can we expect this functionality for MD?
JOHN NEVIN commented
And when is this going to be released!?!? And more importantly, when is MS going to include totals in Matrix exports to Excel??? It is ridiculous that this is not possible - its all MS apps!!! This is a deal breaker at the financial firm I work in.
Mhè?! When will this feature be added?!
Didn't make it to the October 2018 release. Pushed to November 2018. Hoping it doesn't get pushed to December 2018 come November.
Joachim Schirra commented
Given the pre announcement in the feature summary in August 2018, I expected this feature to be available in the September release. However, at least in the feature announcements of this month, it was not yet available which is a bit pity.
Will it be released in October this year or even later?
I happy to see there will be some improvement on that element, it really needs it...
What I'm also missing is the ability to have more than one element on the row level...
Actually it is only supported :
rowlevel measure1 measure2 measure3....
I need :
rowlevel1 rowlevel2 rowlevel3 measure1 measure2 ...
Rowlevel1 could be a Hierarchy like in the demo, but than I would like being able to show other dimensions on the same row...
Actually the Acterys Matrix visual is able to do it, but not in the PBI design... I think it is a feature that belongs in PBI itselfs
will this be available also in direct query mode?
Ralph Kemperdick commented
Please provide the ability to give users a choice on which columns they want to see a Total or not. Maybe as conditional formatting for a specific column in the Matrix.
Yes Please Please bring the feature
Great! This is a very useful tool. I'm looking forward to using it. This was a major impediment to my work with Power BI.
+/- Collapse/ Expand is the only road block I saw with my POC project using Power BI
David Cornwell commented
Good to hear. Hoping Microsoft run some kind of business apps summit with PowerBI content in Australia soon.
Igor George Abdo commented
Does anyone know if there is something similar to solve this until they launch the update?