Forum Discussion

Katt1234's avatar
Katt1234
Frequent Visitor
1 year ago
Solved

Matrix with multiple starting rows that are not nested

I have a table that has multipe columns of data that is relevant. It is being pulled in by Direct Query which is very important for the timing of this task. It has start and end dates. I created a me...
  • Ritaf1983's avatar
    1 year ago

    Hi Katt1234 

    Matrix visual behaves like a pivot table – each field you place in the Rows section adds a level of hierarchy. That’s why it nests fields when more than one is used.

    However, if you're aiming for a flat, non-nested structure that shows multiple source columns alongside your measure (e.g., monthly average), one option is to switch to a tabular layout. You can do this by enabling “Show on rows” and disabling “Stepped layout” under the matrix visual formatting pane. Also, turn off subtotals if needed.

    This way, your fields will appear in a single flat row and not as nested levels.

    With your DATA :

    The pbix is attached

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