Line chart broken

Based on what I see and what you described, here are the most likely causes and how to fix them:

🧩 Root Cause: Data Gaps or Calendar Mismatch

The breaks in your lines (especially when 2023 is added) are likely due to missing sales data for certain Calendar Week Order values or misalignment between your calendar table and fact table.

Here’s a breakdown of what could be happening:

✅ 1. Missing Week Combinations in Sales Data

If even one year is missing a value for a Calendar Week Order, Power BI won’t plot it unless you handle that explicitly.

Fix: Create a full cross join of Calendar × Year

Steps:

• Ensure your calendar table has all 52 weeks for every year (2023, 2024, 2025).

• Use a measure instead of a column for $ Sales Line to avoid gaps.

Here’s a safe DAX example:

Sales Line = 
CALCULATE(
    SUM('Sales'[SalesAmount]),
    REMOVEFILTERS('Calendar'[Month])  // Optional, if Month is used just for axis labels
)

Also, ensure you set the X-axis to “Show items with no data”:

• Click on your X-axis (Calendar Week Order)

• Go to "X-axis" settings in Visual Pane

• Enable "Show items with no data"

🔁 2. Calendar Table Might Be Off

Since you recreated the calendar, make sure these columns are in place and consistently formatted:

• Calendar Week Order (values 1-52)

• Date (continuous and complete)

• Year, Month, Week, etc.

• If you’re using ISO weeks, check for Week 53 and Week 1 edge cases (2023 might have 53 weeks, 2024 is a leap year, so date alignment can shift by a week).

🛠️ 3. Sort Order / Out-of-Order Axis

You mentioned "one week is out of order in March" — double-check the sort by:

• Go to Calendar Week Order

• Ensure it is sorted by a continuous numeric column, like Week Number, not by text (like Month)

✅ Optional Check: Add a Control Table

Create a simple Year × Week helper table (via Power Query or DAX) and join it to your Calendar. Helps ensure you’re plotting over a dense axis.

🔍 Debugging Tip:

Use a matrix visual with:

• Rows: Calendar Week Order

• Columns: Year

• Values: $ Sales Line

This will quickly show you where weeks are missing for a given year.