Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
Proud to be a Super User!
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.
Proud to be a Super User!
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?
Hi,
Thanks for your reply and help. It's nice trick.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |