Forum Discussion

mibu's avatar
mibu
Microsoft Employee
7 years ago

Matrix, Row headers, Stepped layout feature not working

Hello Power BI Community,   I have a matrix... and under Format...  Row headers...  I turn Stepped layout OFF... And yet...  the stepped layout remains in the matrix.   I downloaded the latest ...
Need Help
marcos_osorio's avatar
marcos_osorio
Helper II
7 years ago

Hi, i'm having the same problem, did you find a solution?

I have to display 4 columns and Steppedlayout off it do nothing.

 

Thank you

henrychr's avatar
henrychr
Frequent Visitor
7 years ago

Hi,

Turning off stepped just means you remove the heading and the indentation of the row headers, it will still present the data as a matrix. It's basically a pivot table. Stepped: ON is like the Compact Report layout, and Stepped: OFF is like Tabular Form layout.

 

If you want to show values in every cell of the row, you need to use a table visual.

 

A Matrix will also only give you the scroll bar for the COLUMNS/VALUE piece, not the ROWS.

 

If you need to have a table w/ a measure broken out into columns, you'll need to create individual measures for each column you want.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    but with a table visual, I can;t have both row and column cells ? For example, if I want data for each customer at week grain. Can that be done by table? I want week to be displayed horizontally?