matrix

[ccaswell]

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 grade

What 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]

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

[ccaswell]

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]

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

[ccaswell]

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