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.
I'm hoping to understand what would be the most efficient way to incorporate a dynamic comparison to a top performing teammate on a given measure. For example, I have a dashboard that is intended to be a 'scoreboard' for a selected employee (only viewing 1 employee's data at a time). I am showing their revenue growth on a bar chart that compares that employee's YTD and prior YTD revenue growth, but would also like to have a column that shows the top teammate YTD revenue growth to add some additional context. Is there a relatively straight forward way to do this that anyone has had success with? Thanks so much.
Solved! Go to Solution.
https://drive.google.com/file/d/1VRaQzLoF4WUswZceW9gZx5T-aqHOqHxJ/view?usp=sharing
use this file and see whether it works. Actually when you apply an external filter,
The Data gets restricted and only shows the filtered data hence other one will not show up.
Another way (if above file is not useful) To Show that value you need to create another visual Like Card and restrict the interaction so taht the card will show the Top Value
Proud to be a Super User!
Very helpful, thank you so much. The one hangup seems to be that the slicer on the dashboard that is used to select the employee is also seemingly limiting the employees in the ranking data set. In other words, each person that is selected becomes the #1 ranked and thus their metrics are duplicated for the top performer measure. Is there a way around this?
To make sure I translated the solution correctly, I created 2 measures and used the 2nd (RankReturn) in the visual. Account Manager is the employee and Act YTD Activity Count is the metric i am attempting to rank on.
RankReturn = Calculate([Act YTD Activity Count], filter(all('DIM Account Manager'[Account Manager]),[RANKOFEMPLOYEES]=1),Distinct(Account Manager))
Just add the highlighted one
Proud to be a Super User!
@VijayP
Unfortunately I am still getting the same outcome. I have added a couple of visuals below for 2 different employees to add clarity to the challenge. Endorsements, ARS, and RMS are just types of actions that we are doing a distinct count on. Thanks again for taking the time to help me with this.
https://drive.google.com/file/d/1VRaQzLoF4WUswZceW9gZx5T-aqHOqHxJ/view?usp=sharing
use this file and see whether it works. Actually when you apply an external filter,
The Data gets restricted and only shows the filtered data hence other one will not show up.
Another way (if above file is not useful) To Show that value you need to create another visual Like Card and restrict the interaction so taht the card will show the Top Value
Proud to be a Super User!
@thenerv25 , Do for both YTD and prior YTD
Top 10 Rank YTD= CALCULATE([YTD],TOPN(10,all(Employee[empID]),[YTD],DESC),VALUES(Employee[empID]))
Top 10 Rank prior YTD= CALCULATE([prior YTD],TOPN(10,all(Employee[empID]),[YTD],DESC),VALUES(Employee[empID]))
Top 1 Rank YTD= CALCULATE([YTD],TOPN(1,all(Employee[empID]),[YTD],DESC),VALUES(Employee[empID]))
Top 1 Rank prior YTD= CALCULATE([prior YTD],TOPN(1,all(Employee[empID]),[YTD],DESC),VALUES(Employee[empID]))
Create this measure and add this to the regular Chart what you have created and this will give the context what you require
RANKOFEMPLOYEES = RANKX(all(empid),YTD,,DESC)
Return
Calculate(YTD , filter(all(empid),rankofemployee=1))
Please share your Kudoes and you can watch my Videos on www.youtube.com/perepavijay
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |