Matrix with multiple starting rows that are not nested

[Katt1234]

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 measure that uses to the start and end dates to create a monthly average. I can use a matrix to show the data in a monthly view (dates are the columns and values is the measure I created). However, the default matrix view only allows for one identifier column to be used (see below where name is used). If you add more than one field it the row column then it nests it underneath. Is there any way to have a visual that shows for example, multiple columns of source data alongside the calculations without it nesting underneath? 

Name	Type	Color
1	A	Blue
2	B	Green
3	C	Yellow
4	D	Orange
5	E	Pink

[v-veshwara-msft]

Hi @Katt1234 ,

Following up to see if your query has been resolved and if any of the responses helped.

If you're still facing issues, feel free to reach out.

Thank you.

[v-veshwara-msft]

Hi @Katt1234 ,
We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you.

[v-veshwara-msft]

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.

[v-veshwara-msft]

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.

[Ritaf1983]

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