Forum Discussion
matrix
Hi ccaswell
I think I follow what you are after. I think if you get your table in the following format, you can simply drag the PredictedGrade field to your Columns, then drag SubLevels to your Rows, and then the various Measures to the Values.
Then all you need to do is work out the formulas for the Measures.
Does that help?
PredictedGrade , SubLevels , Measure1, Measure2 --------------------------------------------------------------------
1 , A , 11 , 22
2 , A , 11 , 22
3 , A , 11 , 22
4 , A , 11 , 22
5 , A , 11 , 22
6 , A , 11 , 22
7 , A , 11 , 22
8 , A , 11 , 22
9 , A , 11 , 22
1 , B , 11 , 22
2 , B , 11 , 22
3 , B , 11 , 22
4 , B , 11 , 22
5 , B , 11 , 22
6 , B , 11 , 22
7 , B , 11 , 22
8 , B , 11 , 22
9 , B , 11 , 22
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 Hi 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
Hi,
So every student would have the following data
Name Start Point Predicted Grade
John Doe 1a 4
A Einstein 2c 5
I would want a complete matrix to show at all times that had 9-1 horizontal and 1a,1b,1c,2a,2b,2c etc up to 6C down the left hand side.
The above students would then be plotted as a 1 (or omre if the student data showed more with a 1a start and 4 predict) where they meet in the matrix (e.g where 1a and 4 meet on thr axis.
The most diffcicult thing is how do i get the compelte matrix to show when there aren't every possible horiz/vertical combinations in the student data??
Regards
