Forum Discussion
How to set by default Matrix visual to Expand All levels
Hi Anonymous ,
By default, when a hierarchy is first added into the matrix, it won't be expand all levels. You need to click the button to expand.
For the unsupported feature, you may submit an idea and vote for it: Ideas (powerbi.com)
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the input ghoshabhijeet. 🙂
Even if I save Matrix in expanded form and when I add a new filed in Rows section the newly added filed is collapsed.
This is happening both in PowerBI Desktop and Online Service, any other solution please.
- ghoshabhijeet
Solution Supplier
Anonymous I have tried the solution I have stated in my earlier and it's working at my end. I am using the latest version of Power BI desktop. So, hopefully it should work at your end too. Please check.
This doesn't work. It works only when stable
I'm rather late to this party, so this may go unseen. The following will achieve what you need:
- In the matrix format options:
- Go to "Layout and style presets"
- Make sure you have "Tabular" layout chosen
- Expand all in the visual
- In the matrix format options:
- Go to "Row Headers"
- Turn the "+/- icons" option to OFF
Done!
- In the matrix format options:
