Sort Card (new) Visual in Power BI by Rank

I created a card visual in Power BI to display the Top 3 managers for each of four regions. When I sort the card, it sorts the data alphabetically by manager name.

How can the cards be sorted by Manager Rank instead?

Since ManagerRank is a calculated measure, I am unable to place it in the Categories section.

1 2

I think that a native PBI solution is not available. Here are two workarounds:

The first workaround if Manager rank is a column:

Exchange Manager name and Manager rank. This way Manager rank will be in small multiples and you will be able to sort descending by this rank. It will also display the name of the manager.

The second workaround If the measure complete% can be defined in Power Query you can follow the following strategy:

1. Define the column complete% in Power Query

2. Duplicate Manager name columns and name it Manager name new for exemple.

3. Order by decreasing complete%

4. Define a new index columns that begins at value 1 let's name it Rank Index for example

5. Save and quit Power Query

6. In PBI desktop go to table display on the left pannel and order the Manager name new columns by Rank Index

7. In your initial small card visual replace Manager name by Manager name new and sort the visual in increasing order.

Since we linked index columns to complete% you should get the desired result. You can also filter the visual (in visual filter panel) choosing only index 1, 2 and 3 if you only want to show top 3.