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

[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