Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Calculated columns :
Measures:
Here is an example of a chart I already have which shows the average score for each subject across all schools.
Below are the tables I have for my dataset:
Below is an example of how they would like the outcome to be presented which I am struggling with:
Hi @Anonymous ,
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.
Have you set up the table relationships?
The visual you want is a matrix. What have you got so far?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |