Sort by multiple measures in direct query

[Anonymous]

Hello,

I am trying to sort the below stacked bar chart so that I get all the Highs and then the Mediums and then the Low. My 'High' is getting sorted correctly. However 'Medium' and 'Low' are not sorted correctly. I would want the bar with 4 highs and 3 mediums display above the the bar with 4 highs and 2 mediums. And so on...

Kindly let me know if this can be done

[v-cherch-msft]

Hi @Anonymous

You may refer to below similar post to get a rank. Then you may sort by the rank.

https://community.powerbi.com/t5/Desktop/How-to-Rank-a-list-based-on-2-values-double-rankX/m-p/44076#M17002

Regards,

Cherie