Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to set by default Matrix visual to Expand All levels

Hi Team,   Is there a way to keep Matrix visual by default expanded to all levels (Even after a new row/column is added to Matrix). Our requirement is to show all the levels of matrix without manu...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.

BoundedNutshell's avatar
BoundedNutshell
Frequent Visitor
5 months ago

I'm rather late to this party, so this may go unseen.  The following will achieve what you need:

 

  1. In the matrix format options:
    1. Go to "Layout and style presets"
    2. Make sure you have "Tabular" layout chosen
  2. Expand all in the visual
  3. In the matrix format options:
    1. Go to "Row Headers"
    2. Turn the "+/- icons" option to OFF

Done!