Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
YasirBilal
Helper I
Helper I

image change according to rank

Hi Everyone

 

So i have a data Set which include Emplyoee Employee-image and one month performance points what i want to achive is i need to show rank 1 employee image according to Performance 

 

Dataset look like this 

 

Employee RankEmployee NamePerformanceEmployee image
1Name120image
2Name225image
4

Name3

10image
5Name415image

 

what i want to achive is show image of rank 1 employee and when any other employee have more points and move to rank 1 image change automatically and show that employee image means whoever reach rank 1 after the end of month that employee image update automatically on image visual

 

Any help appreciated 

1 ACCEPTED SOLUTION

HI @YasirBilal 

On the Image Visual in the filter pane select basic filtering and select 1.

However, you would need to make RANKX DAX as a column instead of as a measure.

pranit828_0-1612642512805.png

 





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile

View solution in original post

4 REPLIES 4
PaulDBrown
Community Champion
Community Champion

@YasirBilal 

You need to create a measure for the employee rank using RANKX and then create a conditional measure returning the visual if the Rankx value = 1





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Thank you for Reply

 

Yes i have measure to get rank and i already get the rank but how i use it for image visual 

HI @YasirBilal 

On the Image Visual in the filter pane select basic filtering and select 1.

However, you would need to make RANKX DAX as a column instead of as a measure.

pranit828_0-1612642512805.png

 





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile

Thanks 

this work for me

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.