weeks that juggle between two years

[Anonymous]

Hello to all,

I have a small display in my visual in curve. I display a volume of data per week. By default I filter on a single year via the filter banner on the right.
Except that I have some weeks that juggle between two years. Like week 52 which starts in 2021 and ends in 2022. So week 52 instead of appearing first on the curve, it is displayed in the wrong place and corrupts the display.

Do you have a solution for me? Thank you very much!

[v-henryk-mstf]

Hi @Anonymous ,

Whether the advice given by @amitchandak  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry

[amitchandak · Accepted solution]

@Anonymous , You should consider only a week start or weekend for week year

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1

year week = Year([Week Start date ]) *100 + Weeknum([Week Start date],2)

[Anonymous]

Thank you !