Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sorting Date

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

Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    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]

1 Reply

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    6 years ago

    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]