LeaderBoard Visual

[Sri1999]

Hello, How can I Replicate this report in PowerBI. I want something Similar or much better than this. All values mentiones are calculated as measures, except for names. I tried Cards with names as small multiples , I could only add one measure . I need all measures respetive to each technician.
Context:
1.Technician should sort based on their success Rate and assign rank respectively.

Thanks in Advance. 

[v-shamiliv]

Hi @Sri1999 
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[v-shamiliv]

Hi @Sri1999 
could you please let us know if your issue has been resolved.If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-shamiliv]

Hi @Sri1999 
Thank you for reaching out microsoft fabric community forum.

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[freginier · Accepted solution]

Hey there!

Try following these steps and see if that's what you're lookign for.

Create Measures for Each Metric: You'll need individual DAX measures for each technician's data, such as:

Success Rate: Success Rate = DIVIDE(SUM(Technician[Successful Jobs]), SUM(Technician[Total Jobs]), 0)

total ops ran: Total Ops Ran = SUM(Technician[Total Jobs])

Lead created: Lead Created = SUM(Technician[Leads Created])

Leads sold: Leads Sold = SUM(Technician[Leads Sold])

turnover revenue: Turnover REV = SUM(Technician[Revenue])

Use the RANKX function to create a measure that ranks the technicians based on their success rate (or any other metric). The ranking measure could look like:

Rank = RANKX(
ALL(Technician),
[Success Rate],
,
DESC,
Dense
)

This will assign a rank to each technician based on their success rate, with the highest success rate receiving rank #1.

• Use Card visuals to display the measures you created, such as Success Rate, Total Ops Ran, Lead Created, Leads Sold, etc.

• You can create a separate card visual for each technician and display their data using the calculated measures. You can also add an image or avatar of each technician on top of the cards for better visualization.

To make the cards sort dynamically by the success rate, ensure that you are using the rank you created earlier to sort the cards or matrix.

• In the Visualizations pane, for the technician's rank column, select Sort by Rank.

Hope this helps!

😁😁

[Sri1999]

Hello, Thanks for your reply. I appreciate for your detailed explanation.