Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Week number by year

Hi!  I have a chart showing trend by week number. However when 2020 began my week 1 is placed at the start of my chart and not as sequal to week 52/53. I've tried making a "week + year" column bu...
Need Help
  • TomMartens's avatar
    TomMartens
    6 years ago

    Hey Anonymous 

     

    Just create an additional calculated column that contains an integer value like so

    yearweekno = year('<tablename>'[date]) * 100 + weeknum('<tablename>'[date])

    Then you can use this column to sort your column that contains these values

    week 51 (2019)    week 52 (2019)    week 1(2020)   week 2 (2020)

    This explains the feature "Sort by column": https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column#sort-using-the-sort-by-column-button

    The same article also explains how the sort order can be adjusted in visuals.

     

    Hopefully this provides what you are looking for.

     

    Regards,

    Tom

TomMartens's avatar
TomMartens
Super User
6 years ago

Hey Anonymous 

 

Just create an additional calculated column that contains an integer value like so

yearweekno = year('<tablename>'[date]) * 100 + weeknum('<tablename>'[date])

Then you can use this column to sort your column that contains these values

week 51 (2019)    week 52 (2019)    week 1(2020)   week 2 (2020)

This explains the feature "Sort by column": https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column#sort-using-the-sort-by-column-button

The same article also explains how the sort order can be adjusted in visuals.

 

Hopefully this provides what you are looking for.

 

Regards,

Tom

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    TomMartens Thanks! it worked