Account for Gaps in Line Graph

[JK_PowerBINew]

Hi there,

I have a graph where there is a gap as there is no data for that particular month. This is not a lack of data quality but rather that there were no absences in that month.

Is there a way I can get the graph to connect and simply replace the missing point with a 0?

Thanks!

[JK_PowerBINew]

That worked thank you! Neat trick 😊

[AntonioM · Accepted solution]

Hi, 

If you're using a measure, have you tried adding +0 on the end? That should replace your blank values with 0, so the line should join