Forum Discussion

atoice's avatar
atoice
Frequent Visitor
1 year ago
Solved

Line chart broken

Hi Power BI Community,   Hoping it's a quick / simple fix. I have data from 2023 through current year. I am getting breaks in the line(s) when I add the 2023 data. When using only 1 year, no broken...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

atoice's avatar
atoice
Frequent Visitor
1 year ago

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