Forum Discussion
Matrix with multiple starting rows that are not nested
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
Hi Katt1234 ,
Thanks for reaching out to Microsoft Fabric Community.
As mentioned by Ritaf1983 , the matrix visual handles multiple fields in the Rows area as a hierarchy, which causes the nesting.
To get a flat layout without nesting, you can follow their suggestion to change the Layout to Tabular in the Format pane and also turn off subtotals if needed. This will make the visual appear more like a tabular structure, with your source columns and calculated values side by side.
Hope this helps. Please reach out for further assistance.
Please consider marking the helpful reply as Accepted Solution to assist others with similar issues.
Thank you.
Also thanks to Ritaf1983 for your valuable response.