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.
I am trying to produce a matrix for school grades. Currently, I have a matrix that lists the grades by subject, then teacher, then the name of each grade (one for attainment, one for effort). I have another Query that pulls through the students target grades and I would like them listed as well. When I insert the target values into the Columns field, it puts a target column in front of every other column.
So before it looked like this (obviously, the header cells are merged in the matrix):
Art | English | ||||||
Teacher1 | Teacher2 | Teacher3 | Teacher4 | ||||
Grade | Effort | Grade | Effort | Grade | Effort | Grade | Effort |
A | 1 | A | 1 | A | 1 | A | 1 |
B | 2 | B | 2 | B | 2 | B | 2 |
C | 3 | C | 3 | C | 3 | C | 3 |
Then when I added the new values it looked like this:
Art | English | ||||||||||||||
Teacher1 | Teacher2 | Teacher3 | Teacher4 | ||||||||||||
Target | Grade | Target | Effort | Target | Grade | Target | Effort | Target | Grade | Target | Effort | Target | Grade | Target | Effort |
A | A | A | 1 | A | A | A | 1 | A | A | A | 1 | A | A | A | 1 |
A | B | A | 2 | A | B | A | 2 | A | B | A | 2 | A | B | A | 2 |
A | C | A | 3 | A | C | A | 3 | A | C | A | 3 | A | C | A | 3 |
And what I want it to look like is this:
Art | English | ||||||||||
Teacher1 | Teacher2 | Teacher3 | Teacher4 | ||||||||
Target | Grade | Effort | Target | Grade | Effort | Target | Grade | Effort | Target | Grade | Effort |
A | A | 1 | A | A | 1 | A | A | 1 | A | A | 1 |
A | B | 2 | A | B | 2 | A | B | 2 | A | B | 2 |
A | C | 3 | A | C | 3 | A | C | 3 | A | C | 3 |
Does anyone know if this is possible? I would even settle for having one target column at the beginning of the subject if that's easier?
Thanks
Solved! Go to Solution.
@rmwwgs , This is a hybrid display not supported on the standard matrix as of now
check for custom visual - https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals
For workaround
if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...
vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc
@rmwwgs , This is a hybrid display not supported on the standard matrix as of now
check for custom visual - https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals
For workaround
if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...
vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc
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 |
---|---|
115 | |
101 | |
68 | |
68 | |
43 |
User | Count |
---|---|
145 | |
106 | |
105 | |
90 | |
65 |