How to sort data in power bi clustered column chart in direct query mode?

[pallavisave7]

I have clustered column chart in direct query mode. I want to sort the columns but can not do it by adding new sorted column due to direct query mode and I can not switch to exctract mode. 

How to achieve sorting without adding new column?

[v-jingzhang · Accepted solution]

Hi @pallavisave7 

In DirectQuery, you can also create a new column for sorting although it doesn't display the data in the table. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.