Sorting Weeknum,Year and month in direct query mode

[Rup10]

Hi 

I have plotted cluster column chart by using year,month and weeknum as below : 

It is should come like jun25,jun 26, jul26 and jul27. I tried to sort data but it is giving me below error : 

Can someone please help me with sorting.

Thanks in advance

[v-janeyg-msft]

Hi, @Rup10 

The easiest way is to create an index column in pq, then use it as sort column in desktop.

Like this:

Best regards

Janey guo

[amitchandak]

@Rup10 , to sort you need to bring a column in the format YYYYWW.

Check if in direct query mode, you can add a new column like, if needed

Week sort = [Year]*100 +[Week]

mark that as sort column