Forum Discussion
Helper IIIControlling column expansion in a matrix view
Hi RossChevalier ,
Currently, it is not supported to expand and collapse columns header in Matrix. You could vote the idea up and submit comments to get the feature fixed quickly. And it is voted by about 4000+ users. I think it will be fixed soon.
Add expand/collapse feature to column headers
As a workaround, you could reference the similar thread about changing column dynamically by a slicer.
Dynamic column selection for matrix visual
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi RossChevalier ,
I created some sample data, is this what you want?
If yes, you can enable the +/- Icons function in Row headers section, please see the bottom right in the above screenshot.
If no, please show me what you want.
Thanks.
Aiolos Zhao
Helper IIIThank you so much. I can see how to do this with rows, what I wanted to do is something similar in columns.
For example, I would like to be able to have selective expansion, such as keeping the quarters for 2018 and 2019 collapsed but the quarters for 2020 expanded. Because of the number of row items, readability requires me to put the dates in columns. If there is a +/- option for columns, I have plainly missed it so coaching on this will be appreciated.
v-xuding-msftCommunity Support
Hi RossChevalier ,
Currently, it is not supported to expand and collapse columns header in Matrix. You could vote the idea up and submit comments to get the feature fixed quickly. And it is voted by about 4000+ users. I think it will be fixed soon.
Add expand/collapse feature to column headers
As a workaround, you could reference the similar thread about changing column dynamically by a slicer.
Dynamic column selection for matrix visual
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.