Sorting table by highest value

[Anonymous]

Hi Community,
I am creating a leaderboard that uses a SharePoint list as a data source. I need the individual with the most points to appear on top and to follow that order. I suspect I need to use the rank function but not sure... ?

Report

Data source

[v-juanli-msft]

Hi @Anonymous 

Please refer to:

https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/

The order should be 108, 70, 15, right?

Best Regards
Maggie

[amitchandak]

You should able to sort on column/measure in all the visuals.