Forum Discussion
AntWickenden
3 years agoFrequent Visitor
Selecting highest result from 4 values and displaying a description for that.
I have been replicating a retired excel KPI pack within Power BI and have come across something I need help with. The KPI pack relates to shipping and includes delays in the door to door shipping...
amitchandak
Super User
3 years agoAntWickenden , My advice would be to create Rank or TOPN and use them as a visual level filter or use the Index function.
In the above case also create a count measure and plot with Delay Reason
TOPN: https://youtu.be/QIVEFp-QiOk
TOPN with Numeric Parameter -https://youtu.be/cN8AO3_vmlY?t=26448
Power BI Index function: Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U
AntWickenden
3 years agoFrequent Visitor
Thanks amitchandak
Let me try that and see what happens...