Year-End overlap issue for period-to-period comparison bar chart

[dakesel]

I have a chart that updates every Sunday showing the comparison of "future orders for the next 12 weeks" compared to the same 12 week period for the prior 2 years.  It works fine until we get close enough to year end that the 12 week future period overlaps the year-end boundary.  Any suggestions for how I can get the chart to still use the year and week number dimensions like this, but display the bars for the last few weeks of this year and the first few weeks of next year?

[Aditya_Chitale]

What do you mean by overlap yearend boundary ? can you share an example with sample data ?

Also, for 45th week of  2023, the future 12 week would end at 4th week of 2024 ? So what logic goes here for choosing  3rd week as ending 12th week ?

Regards,

Aditya