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.

     

lfholland's avatar
lfholland
Advocate I
2 years ago

I believe this will resolve it: go to the Matrix settings, Row Headers > Options, turn off Stepped Layout.

  • sahabatsuria's avatar
    sahabatsuria
    Frequent Visitor
    1 year ago

    I don't see this as an option though? I'm using Power BI version 2.143.878.0 64-bit (May, 2025)

    • alakay_10's avatar
      alakay_10
      New Member
      1 year ago

      If you choose "Tabular" in the Format Visual part of the Visualization pane while on the Matrix visual within "Layout and style presets" then back in the Matrix visual right click on each column with expansion capability and select "Expand to next level" for each, it gets the same effect since the Stepped Layout option appears to not be available anymore.

       

  • Cinthya_Darci's avatar
    Cinthya_Darci
    Frequent Visitor
    2 years ago

    Yes, this works! Thanks!