matrix

Question

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, 2b etc up to and including 6.I then wan to plot my data which may be in the form of a table with name, start point, predicted gradeWhat is the best way to do it?I'd also like to be able to filter by subject/assement point and coour code elements of it...is this possible?Regards

phil_seamark · Answer

Hi&nbsp;ccaswell&nbsp;I think I follow what you are after. &nbsp;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.&nbsp;Then all you need to do is work out the formulas for the Measures.&nbsp;Does that help?&nbsp;&nbsp;PredictedGrade , SubLevels , Measure1, Measure2
--------------------------------------------------------------------1 , A , 11 , 222 , A , 11 , 223 , A , 11 , 224 , A , 11 , 225 , A , 11 , 226 , A , 11 , 227 , A , 11 , 228 , A , 11 , 229 , A , 11 , 221 , B , 11 , 222 , B , 11 , 223 , B , 11 , 224 , B , 11 , 225 , B , 11 , 226 , B , 11 , 227 , B , 11 , 228 , B , 11 , 229 , B , 11 , 22&nbsp;&nbsp;

ccaswell · Answer

Hi,&nbsp;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?&nbsp;&nbsp;no result123456789Total No. PupilsW - Working Towards&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;01a&nbsp;&nbsp;21&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;31b&nbsp;&nbsp;21821&nbsp;&nbsp;&nbsp;141c1&nbsp;215165&nbsp;&nbsp;&nbsp;302a1&nbsp;&nbsp;&nbsp;&nbsp;84952&nbsp;652b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6231122c&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0

v-caliao-msft · Answer

Hi ccaswell,
&nbsp;
We can get a similar result by using Matrix visual in Power BI. 
&nbsp;
In your scenario, please provide us some sample data, so that we can make further analysis.
&nbsp;
Regards,
Charlie Liao

ccaswell · Answer

Hi,&nbsp;So every student would have the following data&nbsp;Name &nbsp; &nbsp; &nbsp; &nbsp;Start &nbsp;Point &nbsp; &nbsp; &nbsp; Predicted GradeJohn Doe &nbsp; &nbsp; &nbsp; 1a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4A Einstein &nbsp; &nbsp; &nbsp; 2c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp;I would want a complete matrix to show at all times that had &nbsp;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

Forum Discussion

matrix

4 Replies

Related content

Matrix table

sorting matrix

Customize subtotal in matrix

Matrix Row Conditional Formatting

Matrix formatting

	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