How to skip blank value in power bi line chart

[lilbsb]

So i create a line chart for my dashboard, the x axis is from the week. The problem is when it comes to another year like 2024, it show a blank value between last 2023 week (202352) and 2024 first week (202401) and my line is bit messy. Anyone know how to fix that?

[Fowmy]

@lilbsb 

You can check if the mesure youare ausing returns a value using if like:

New Measure = IF ( NOT ISBLANK(YourMeasure) , YourMeasure )

[lilbsb]

well actually i dont have blank value on my week table, 202401 came after 202352 😄 

[lilbsb]

Okay thanks for the help, i will read the link first, thankyou once again! aprriciate that 😄

[zenisekd]

@lilbsb  follow up on this discussion: https://community.fabric.microsoft.com/t5/Desktop/Non-continuous-line-chart-data/m-p/13722

Several approaches are mentioned. 

Kudos and mark as solution appreciated.