Forum Discussion
Multiple row headers in matrix table visual
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
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.
3 Replies
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.
Hi,
Thanks for your reply and help. It's nice trick.
