Unable to sort month in chronological order in power query in visual studio 2019

[Anonymous]

Hi, We are building semantic layer datamodel in azure analysis service. In visual studio 2019 when we are conneting to tables, power querry window is opening. But we are unable to sort month in chronological order using Sort by column name.

This sort by column name is available in power bi desktop in power querry editor. Is there any way to sort this month column in visula studio 2019 Power bi querry editor.?

[dax · Accepted solution]

Hi @Anonymous , 

I test this in my environment, I find that "sort by " is in properties windows instead of in power query. If you want to set "sort by", you could choose corresponding column , then set this like below

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.