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 , ...
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]

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]