Forum Discussion
Line chart broken
Hi atoice ,
Considering the current limitations in sharing the dataset due to character constraints and security policies, I would recommend raising a support ticket. They will be able to assist you more effectively.
To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
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.
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.
Hi V-tsai,
I did try to add the formula you had. it did put zero line in. But it was still broken. It definitely is the calendar piece. But I did attempt to manually change "calendar month" to March, but thinking it's maybe because the week ending is in April. I did the same with the other breaks in the line to align the same months for those weeks. But it still didn't do it. It's something in how the calendar is aligned. I can't attached the file, or I would.
I appreciate your additional help.Hi atoice ,
Based on what you described, the line chart breaks are due to how the calendar assigns weeks to months especially in cases where a week ends in a different month than most of its days.
To resolve this, I recommend reviewing your calendar logic to ensure that weeks are consistently attributed to the correct month either by using the week’s start date or basing it on most of the week’s days.
Avoid manually changing month labels, as this often leads to misalignment. Instead, define clear logic in Power Query or DAX when building your calendar. Also, make sure your chart uses the Date field from the calendar table as the X-axis and that the relationship to your fact table is properly set.
Enabling “Show items with no data” and wrapping your measure in COALESCE([Measure], 0) will help maintain line continuity once the calendar alignment is fixed.
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.
Hi v-tsai,
Thank you again for follow up. I don't know how to make a calendar in Power Query / Dax. I did use the formula, but it didn't work because of the calendar. In both ways, modifying the calendar to adjust for weeks 13, 26, 35, and 48 did not work. I can't paste the rows since it tells me I am over the character limit. I'm going to leave it as it with the team as that layout was the way they had it (in Excel). I just wanted to make it a little cleaner. I tried to take some snips with weeks in question (2023) and the comp week 13 for 2024.
