Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 @Anonymous , 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 @Anonymous , 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.
User | Count |
---|---|
85 | |
80 | |
77 | |
49 | |
41 |
User | Count |
---|---|
114 | |
56 | |
51 | |
42 | |
42 |