Multiple row headers in matrix table visual

[Saxon10]

Hi,

I have three columns in a table which is Order, Team and Team Code and status.

I added Order and Team columns in matrix table Row Level but both columns are showing within the same row but I would like to see separately (Order and Team) in matrix table.

Order	Team	Team Code	Status
1	IND	DD1	OK
1	IND	DD1	OK
1	IND	DD1	OK
2	ENG	DD2	OK
2	ENG	DD2	OK
2	ENG	DD2	OK
3	UK	DD3	OK
3	UK	DD3	OK
3	UK	DD3	OK
3	UK	DD3	OK
4	AUS	DD4	NOT OK
4	AUS	DD4	NOT OK
4	AUS	DD4	NOT OK
5	SRI	DD5	NOT OK
5	SRI	DD5	NOT OK
6	PAK	DD6	OK
6	PAK	DD6	OK
6	PAK	DD6	OK
7	WI	DD7	OK
7	WI	DD7	OK
8	SA	DD8	OK
8	SA	DD8	OK
8	SA	DD8	OK
8	SA	DD8	OK
8	SA	DD8	OK

Matrix visual:

If I want to see the team then I need to expand every single order. 

In Excel I am can add multiple columns in row level and I can ignore the sub total. I would like to get the same thing in Power BI matrix table in visual level.

Any advise please

Desired output

[vanessafvg · Accepted solution]

you can turn off the stepped layout in the row headers settings, you will still need to expand but its on one line

see if that helps.

[Anonymous]

Agreed, its a nice trick.  But if you have many rows, sub optimal.  How would one line up both on the same row WITHOUT having to expand?  

[Saxon10]

Hi,

Thanks for your reply and help. It's nice trick.