Axis Order based on Week Numbers for Overlapping Academic Years

[jessica-ko]

My organisation operates on academic years and academic weeks.

The start of an academic year occurs in august and ends in July. 

Example - academic year 2024/25 will start first week of August 2024 = Week 1. 

The business want to see a visualisation comparing three years worth of cumulative sales data for each academic year by Term. The graph should show the first academic week of sales for each year up to the current academic week number. They want to see this data in a line chart. 

The problem is sales for one academic year can start before the academic year begins and we can see returns and sometime sales figures after the academic year ends.

Example for year 2023-2024 sales start to come in week 16 of the previous academic year 2022-23 as we publish our courses  earlier for enrolments. Meaning week 16 for academic year 2023-24 will occur again once the year actually starts.

Given we have 52/53 weeks in a year this means to put this data in a cumulative line graph for three year will show a overlap for each week. 

I have attached a link to a sheet with data for 3 academic years. and below is a chart to show somewhat of the desire outcome, what is not shown on the chart is the axis showing the re-occurring week numbers which is needed. 

https://docs.google.com/spreadsheets/d/1sdweGkPHqg3YnSZtd5LnrnPaI7B5_4HtKt7LAEyQ0WI/edit?usp=sharing 

Please help, many thanks!

[foodd]

Hello @jessica-ko , remember to adhere to the decorum of the Community Forum when asking a question.

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.