help with sorting by ascending order by earliest months

[mespiritu]

Please help with sorting I tried all the tricks I know. see screenshots below as an example

added a custom column to help with sorting by still underable to sort

[wdx223_Daniel · Accepted solution]

select the first column and "Sort By Column" of second column

[shafiz_p · Accepted solution]

Hi @mespiritu  You have to sort Employment_Retention in the power bi desktop by column "Sort by Emp Ret". To do this in power bi desktop, go to Table View > Select Employment_Retention > then click Sort By Column option > Select column "Sort by Emp Ret" and you are done. See image how you can achieve this in power bi:

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz

[wdx223_Daniel · Accepted solution]

select the first column and "Sort By Column" of second column

[PwerQueryKees]

I am not an expert in PBI, but your Power Query does not seem to be the problem. One of the PBI experts may be able to help you.