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
I would love to see this happens soon!
RE: Matrix +/- Collapse/ Expand Buttons
Any Update on this?
RE: Matrix +/- Collapse/ Expand Buttons
Absolutely agree, fantastic product, but this is one thing outstanding that would tip it from good to great.
RE: Matrix +/- Collapse/ Expand Buttons
Please add this option as soon as possible :) thanks
RE: Matrix +/- Collapse/ Expand Buttons
would be of huge benefit within NHS where there are a number of layers to diagnosis for example, had hoped to find this functionality already there.
RE: Matrix +/- Collapse/ Expand Buttons
Must have feature in Power Pivot for better use of canvas!
RE: Matrix +/- Collapse/ Expand Buttons
Very Important for huge data to present in cross matrix
RE: Matrix +/- Collapse/ Expand Buttons
please
RE: Matrix +/- Collapse/ Expand Buttons
Yes please prioritize this! We have reports with over 300 columns looking to migrate to Power BI. We want the default state of the report to only display 100 columns when exported to Excel, and user will expand the columns based on need.
RE: Matrix +/- Collapse/ Expand Buttons
I would also give all my voting points for controlling subtotals! Any date?