Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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 Rank | Employee Name | Performance | Employee image |
1 | Name1 | 20 | image |
2 | Name2 | 25 | image |
4 | Name3 | 10 | image |
5 | Name4 | 15 | image |
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
Solved! Go to 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.
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 |
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
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.
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
User | Count |
---|---|
114 | |
73 | |
57 | |
47 | |
38 |
User | Count |
---|---|
167 | |
119 | |
61 | |
58 | |
53 |