Forum Discussion

afaro's avatar
afaro
Icon for Helper III rankHelper III
2 years ago
Solved

How to disable hierachy display in matrix for multiple rows?

I have many columns of the table as rows in a matrix and no columns in matrix. The values are a measure. The rows in this matrix appear such that values of column2 is nested inside values of column1 ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, afaro 

    With your matrix visual selected, go to the Format pane  in the Visualizations pane. Expand the Row headers section, find the Stepped layout option, and toggle it to Off. This action prevents the automatic nesting of values from column2 under column1, aligning them in the same row instead.

     

     

    For more details, refer to the documentation:

     

    Create a matrix visual in Power BI - Power BI | Microsoft Learn

     

    How to Get Your Question Answered Quickly 

    Best Regards

    Yongkang Hua

    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
2 years ago

Hi, afaro 

With your matrix visual selected, go to the Format pane  in the Visualizations pane. Expand the Row headers section, find the Stepped layout option, and toggle it to Off. This action prevents the automatic nesting of values from column2 under column1, aligning them in the same row instead.

 

 

For more details, refer to the documentation:

 

Create a matrix visual in Power BI - Power BI | Microsoft Learn

 

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.