Skip to main content
cancel
Showing results for 
Search instead 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

Reply
GeoSans
New Member

Ranking columns

Hello!

I have the following table:

StudentExercise 1Exercise 2Exercise 3
Merry542
John865
Pedro275

 

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
olgad
Super User
Super User

In Power Query Editor, pick Ex 1, 2,3 columns, right click-unpivot columns

olgad_1-1709647268919.png

 

Then, create a score measure Sum(Value) or Avg(Value)
Then Rank measure: 

 

 

olgad_0-1709647250785.png

 


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

View solution in original post

5 REPLIES 5
AmiraBedh
Resident Rockstar
Resident Rockstar

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

 

AmiraBedh_0-1709647501395.png

 


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
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
olgad
Super User
Super User

In Power Query Editor, pick Ex 1, 2,3 columns, right click-unpivot columns

olgad_1-1709647268919.png

 

Then, create a score measure Sum(Value) or Avg(Value)
Then Rank measure: 

 

 

olgad_0-1709647250785.png

 


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

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

GeoSans_0-1709650605573.png

 

GeoSans
New Member

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

olgad
Super User
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?


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

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.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.