Forum Discussion
Matrix with multiple starting rows that are not nested
- 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
Hi Katt1234 ,
Just wanted to check if the reponses provided has met your needs. If yes, please consider marking the helpful reply as "Accepted Solution" to assist others with similar queries. If further assistance is needed, please reach out.
Thank you.