Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello!
I have the following table:
Student | Exercise 1 | Exercise 2 | Exercise 3 |
Merry | 5 | 4 | 2 |
John | 8 | 6 | 5 |
Pedro | 2 | 7 | 5 |
I would like to visualize a ranking with the exercise in order to see which one were easier for the students and which were the hardest for them.
How can I do this?
Thank you!
Solved! Go to Solution.
In Power Query Editor, pick Ex 1, 2,3 columns, right click-unpivot columns
Then, create a score measure Sum(Value) or Avg(Value)
Then Rank measure:
For each exercise, you would create a measure like this:
Average Exercise 1 = AVERAGE(YourTableName[Exercise 1])
Average Exercise 2 = AVERAGE(YourTableName[Exercise 2])
Average Exercise 3 = AVERAGE(YourTableName[Exercise 3])
In Power Query Editor, pick Ex 1, 2,3 columns, right click-unpivot columns
Then, create a score measure Sum(Value) or Avg(Value)
Then Rank measure:
I created a mesure called Score doing Sum(Values) but it returns me the same number
Hi Olgad!
I would like to see it in a table ordered by from the hardest to the easiest ones but I'm one to visualize it in a different way
How would you like to display it in your report? What shall be the output, please? Exercise 2 is the hardes, 1 is following and 3 or?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
76 | |
74 | |
56 | |
45 |
User | Count |
---|---|
117 | |
105 | |
77 | |
66 | |
64 |