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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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