Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
2 years ago

matrix visual with nested rows and columns

how to create matrix visual with below nested rows ( state->city->customer name) and columns (year->quarter) in power bi?

 

 

 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi powerbiexpert22 

     

    Maybe you can try to use the stepped layout:

    You can easily adjust the stepped layout settings. With the matrix visual selected, in the Format section (the paintbrush icon) of the Visualizations pane, expand the row headers section. You have two options: the Stepped layout toggle (which turns it on or off), and the Stepped layout indentation (which specifies the indentation amount, in pixels).
    Here is the link for your reference:

    Stepped layout with matrix visuals

     

     

    Best Regards

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

    • powerbiexpert22's avatar
      powerbiexpert22
      Impactful Individual

      Hi Anonymous ,

       

      There is no stepped layout option available in column headers

       

       

  • Any updates on this?  Will we get this feature back? not all reports are drillable, sometimes we just need information not to be nested!