Forum Discussion
Ranking columns
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!
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:
5 Replies
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
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?
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
