cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JP91
Regular Visitor

measures in a table/matrix

Hi,

I am a student currently doing a work placement. I have been tasked with creating a visual based on the clients needs they would like this to be in the form of a matrix. I have been able to create the measures required to achieve this but am currently struggling with being able to visualise it the way they have asked.

 

Field List:

 

JP91_0-1606993376622.png

 

Calculated columns :

 

JP91_2-1606993376642.png

2.png

 

Measures:

 

7.png

4.png

5.png

7.png

6.png

7.png

 

 

 

Here is an example of a chart I already have which shows the average score for each subject across all schools.

8.png

 

Below are the tables I have for my dataset:

9.png

 

10.png

 

11.png

 

12.png

 

Below is an example of how they would like the outcome to be presented which I am struggling with:

table example.PNG

 

2 REPLIES 2
v-yingjl
Community Support
Community Support

Hi @JP91 ,

Based on your description and sample data, not certain what is your expected output.

In your datasets, there are only 4 students from school A, what about others? Have you created relationships between these tables? 

Could you please consider sharing more details about this issue or a sample file for further discussion?

In addtion, if you want to use a matrix to show the result which is simliar with the last picture, I'm afraid you could not achieve this because measrue can not be used as rows / columns in matrix.

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

HotChilli
Super User II
Super User II

Have you set up the table relationships?

The visual you want is a matrix.  What have you got so far?

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.