Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
Solved! Go to 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.
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 ...
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.
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.
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 ...
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.