Creating 3 indicidual cards for top 3 results

[JayKarim]

Hi Power BI Community,

I'm building a performance dashboard. What I would like to do is display the top 3 performers (by GBP), in 3 seperate cards

e.g.

Card 1 = Top performer (company name)

Card 2 = Seconde best performer (company name)

Card 3 = Third best performer (company name)

Card 1 i'm able to produce, I used the 'top N' filter a

Card 2 & Card 3 - how do I only display the second and third best performer? what is the solution for this

Many thanks in advance

Jay 

[PaulDBrown · Accepted solution]

You can rank the highest performance using RANKX and then filter the cards to show rank 1, 2 or 3