Forum Discussion

mespiritu's avatar
mespiritu
Icon for Helper I rankHelper I
1 year ago
Solved

help with sorting by ascending order by earliest months

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

 

  • 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

3 Replies

  • 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.

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Icon for Community Champion rankCommunity Champion

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

  • 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