cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## 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!

1 ACCEPTED SOLUTION
Super User

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:

PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
5 REPLIES 5
Community Champion

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])``````

Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696
Super User

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:

PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
New Member

I created a mesure called Score doing Sum(Values) but it returns me the same number

New Member

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

Super User

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?

PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.