Wrong order of week at the turn of the year

[PetrK]

Hello, I'm faceing this issue.
In "Line and stacked columns chart" in x-axis I have year, month and week. Week is calculated according iso standard by formula week= WEEKNUM([Date], 21). And if happen that week 1 contains some days from previous year it display this part of week at the begining of the december. More clear it is visible on the picture. There are highlighted days 30. and 31. December 2024 which are in the week 1 of the year 2025 by the calculation of iso standard. And chart display these two days  of week1 on first place in december. 
Do you know how to display this part of week 1 at the end of december. So order of week will be 48, 49 , 51 , 52, 1, 1.

Thank you   

[PijushRoy]

Hi @PetrK 

Create another column for YearWeekNo
YearWeekNo = Year(Table[Date])&WEEKNUM([Date], 21)

Now change the exisitng WEEKNUM column Sort By of the new column YearWeekNo
Here is the option

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[PetrK · Accepted solution]

Thank you for you idea. Unfortunately it doesn't work. It display this message 

But it change my mind and finally I a bit modified my formula for week calculation and from first days of week 1 which are still in the old year I create week 54. It is not great solution but much better than original one.