Sort by another column for direct query

[admin_xlsior]

Hi guys,

Are we able to do Sort by another column with Direct Query method ?

I have Date dimension, get from Direct query to SQL, I want to sort the month but coudn't.

Thanks,

[v-yulgu-msft · Accepted solution]

Hi @admin_xlsior ,

Here is a similar thread for your reference:

Sorting a text column using Direct Query

Best regards,

Yuliana Gu