Sean on 07 Aug 2015 03:38:36
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!
Administrator on 17 Nov 2018 02:34:25
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
- Comments (234)
RE: Matrix +/- Collapse/ Expand Buttons
Great News!
RE: Matrix +/- Collapse/ Expand Buttons
This feature is super useful for priority analyses helping executives manage by exception where they can drill down only when a lower element is outside target. See this example: https://www.youtube.com/watch?v=tondy2DgcQw
RE: Matrix +/- Collapse/ Expand Buttons
This is a must have for executives that want to manage-by-exception! Please get this up and running quickly.
RE: Matrix +/- Collapse/ Expand Buttons
Please get this started.....It will be great for companies with multiple locations and to drill into data points.
RE: Matrix +/- Collapse/ Expand Buttons
Super must!!
RE: Matrix +/- Collapse/ Expand Buttons
Would like to see this for the regular table as well. I'd like to be able to group rows by the value of a column (New, Used, Parts) to better visualize my data. Thanks
RE: Matrix +/- Collapse/ Expand Buttons
it is needed
RE: Matrix +/- Collapse/ Expand Buttons
This is a duplicate of: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9207006-matrix-collapse-expand-buttons
The 2 ideas combined have over 600 votes.
RE: Matrix +/- Collapse/ Expand Buttons
This is a must have for representing and navigating hierarchical data.
RE: Matrix +/- Collapse/ Expand Buttons
A must have !