Sorting Date

[Anonymous]

Hi,

I need help.!

i have a date clolum and Weeknum type as below.

the problem is when i use the column in the visual graph, the order of week is not what i want.

currenly it looks 2018 1 , 2018 11, 201812, 2018 2, . . . . 2018 9. ..

I want it to be  2018 1,  2018 2, 2018 3 , . . . . 2018 10, 2018 11, 2019 12 

Is there any idea?

thank you,

CL

[jdbuchanan71 · Accepted solution]

Hello @Anonymous 

Add a column to your table like so.

WeekSort = YEAR('Calendar'[Date])*100 + WEEKNUM('Calendar'[Date],2)

Then select the [Week] column and set the Sort by column to [WeekSort]