Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

WeekNum sequence issue

Hi there,   I created a Date table as following: The weekNumber dax is: WeekNum = "Wk" & WEEKNUM('Date'[Date])     However, the weekNumber does not work well in chart sequence. The ac...
Need Help
Show and Tell
  • richbenmintz's avatar
    richbenmintz
    5 years ago

    Hi Anonymous ,

     

    you need two columns, one with the week as an int, the other as the week as a string, then you will sort the week as a string by the week as int. see image below

     

     

richbenmintz's avatar
richbenmintz
Resident Rockstar
5 years ago

Hi Anonymous ,

 

you need two columns, one with the week as an int, the other as the week as a string, then you will sort the week as a string by the week as int. see image below

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Got it! Thank you!!

  • richbenmintz's avatar
    richbenmintz
    Resident Rockstar
    5 years ago

    Hi Anonymous 

    Did you choose the week as it field as the sort by column for your weeknum field? in your image it looks like you set the sort by column of the intweeknum column and not the weeknum column. If you look at the solution provided, I have selected the weeknum column and set the sort by column property for that column.

  • richbenmintz's avatar
    richbenmintz
    Resident Rockstar
    5 years ago

    No Probs!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi richbenmintz 

    opps...sorry, come again,

    I created intWeekNum in "Date" table,

     

     

    the visual is using data from "General Performance" table.

    So although I choose "sort by" is "intWeekNum" in table "Date", but the visual is not using it.

     

    In the visual, there is no place to choose sort by "intWeekNum"

     

     

    Any further settings needs to be changed?

    Thanks in advance.

    H

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Appreciate your patience👍 to a new comer to power BI !🤣

  • richbenmintz's avatar
    richbenmintz
    Resident Rockstar
    5 years ago

    Hi Anonymous ,

    Glad to help out!