Forum Discussion
matrix
Hi, I want to create a grade matrix to plot start point against predicted grade. I want predicted grade to be horizontal from 9 down to 1 and start point to be sublevelled.....i.e. 1a, 1b, 1c, 2a, ...
Hi,
I'd also want the matirx to show as an empty complete grid with the students' plotted on it...like this one...is that possible even if studetn don' fill every box?
| no result | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Total No. Pupils | |
| W - Working Towards | 0 | ||||||||||
| 1a | 2 | 1 | 3 | ||||||||
| 1b | 2 | 1 | 8 | 2 | 1 | 14 | |||||
| 1c | 1 | 2 | 1 | 5 | 16 | 5 | 30 | ||||
| 2a | 1 | 8 | 49 | 5 | 2 | 65 | |||||
| 2b | 6 | 2 | 3 | 1 | 12 | ||||||
| 2c | 0 |
v-caliao-msft
Microsoft Employee
Microsoft EmployeeHi ccaswell,
We can get a similar result by using Matrix visual in Power BI.
In your scenario, please provide us some sample data, so that we can make further analysis.
Regards,
Charlie Liao