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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

you have to build a yearweeknumber column with data as 201951, 201952, 201953, 202001, 202002... and then you have to order your week year (i.e. week 52 (2019)...) by column yearweeknumber in the model tab

 

Lorenzo

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous 

    Thanks, it almost worked. But my yearweeknumber makes it 201952 and 20201 (not 202001) and therefore rates 201952 a higher value.

    /Mikkel