How to create a custom sort order for a visualization?

Hello v-cherch-msft/Cherie,

Thanks a lot for your time. 

I had already implemented this solution as mentioned in my question. :) But i was wondering if there was any other way to do so because i am having four graphs on one dashboard which i need to custom sort so i thought making four tables is a bit excessive!

Also for one report i have my x-axis as first day of the week given as mm/dd, as it's a custom created field its stored as text thus causing troubles in getting a proper sort order. I have fixed it by appending the week number to it but the executives don't like it! If you happen to know any way to fix this also then that would be awesome!

Thanks a lot!

Regards,

Harshal