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.

Hi Solomon,

First thank you for your support. There is data for every week.

1. I did use your measure - and the gap is still there. I could not find the enable "Show items with no data."

2. I feel it is the calendar. The week ending (how data is pulled) has 2023 week numbers falling into the next month vs. 2024 and 2025. (ie week ending 4/1 for week 13 falls into April in 2023, while 2024 and 2025 fall in March).

3. I redropped the week number back in and it went back in order (even though the data still showed the gaps.

I have never created a control table. So, I will skip and try when I have more time.

I removed the Month for the X-axis and it is continuous. I will accept this layout.

Enjoy your weekend.

MT

Hi atoice ,

Thank you for reaching out to the Microsoft Fabric Community. Also thank you SolomonovAnton  for your input.

Based on your explanation, the issue appears to be calendar misalignment, specifically how week-ending dates are handled differently in 2023 compared to 2024 and 2025. Although your data is complete, inconsistent week-to-month mapping is causing the line breaks.

To fully resolve this:

• Please ensure your Calendar table consistently aligns week-ending dates across all years.
• Verify that your X-axis field is sourced from the Calendar table. This will enable the “Show items with no data” option under Visual >Format > X-axis.
• Optionally, update your measure to handle missing points:

Sales Line = COALESCE(SUM('Sales'[SalesAmount]), 0)

Your workaround using a continuous X-axis is a good interim solution, but correcting the calendar structure will permanently fix the line breaks.

I hope this will resolve your issue, if you need any further assistance, feel free to reach out.

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thankyou.