Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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 April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
103 | |
63 | |
45 | |
37 | |
35 |