Display Top 5 Ranked Table Items in Cards

[Datagulf]

I have a table visual that  I have created with the items and the respective KPI's they are ranked in a list as shown below.

Name	KPI 1	KPI 2	KPI 3	KPI 4	KPI 5	Rank
James	95	78	69	78	80	1
Lisa	77	94	68	79	77	2
John	67	76	78	93	78	3
Festus	77	66	92	77	75	4
Nas	74	91	65	76	76	5
Will	90	73	75	73	64	6

I want to put those Names as ranked in cards with the label rank in a multi-row card in some sort of Podium showing highest to lowest. What would be the ultimate way to display those 5 cards using DAX? Answers appreciated.

[v-stephen-msft · Accepted solution]

Hi @Datagulf ,

Use Multi-row card, put the rank column into filters, then set show items when the value is less than 6.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Datagulf · Accepted solution]

Thanks @v-stephen-msft , however, I needed these names, each in their card and with the corresponding Rank. So something like ;

1
Festus 

2
James 

and so on ... 

[v-stephen-msft · Accepted solution]

Hi @Datagulf ,

Use Multi-row card, put the rank column into filters, then set show items when the value is less than 6.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Datagulf · Accepted solution]

Thanks @v-stephen-msft , however, I needed these names, each in their card and with the corresponding Rank. So something like ;

1
Festus 

2
James 

and so on ... 

[v-stephen-msft · Accepted solution]

Hi @Datagulf ,

Add the rank column into the visual, and sort by the rank column.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.