Currently you can choose to sort based on another column, such as sorting a month name by the month number. However, this option does not exist in direct query mode. Please extend this functionalit...
This functionality already exists. With a DirectQuery, in Report Mode, you see no data, yes, but you can see the fields section, choose the column to be sorted, and you can find 'sort by column' is active, then, selection the sequence column to sort by.
