Display Dates on Line Graph without data

[Anonymous]

I know there are a lot of other questions similar to this, but I couldn't find an answer for my specific example, so sorry if this is a duplicate. 

I have this small table as my data source, where the Net column is simply the Collections minus Payments for that day.

On my report, I have a graph of the month-to-date net amount to plot it's change (below). The graph jumps from 10/17 to 10/26, since there is no data. However, when I use a sliding date slicer, the tile shows that the net amount hasn't changed. I want to be able to show on the graph that the net remained the same from 10/17 to 10/25, and then jumped up on 10/26.

I know the solution to this would be to add lines for each of those dates, with 0.00 values, however I cannot. The above is just an example since I can't share the real data. The file I'm actually having trouble with is thousands of lines long and is an auto-generated report that we cannot alter before feeding into Power BI.

Furthermore, the dates that do not have data (10/18-10/25 in the example above) will always be different, so it needs to be something that Power BI automatically handles.

Any help is MUCH appreciated!

[v-chuncz-msft · Accepted solution]

@Anonymous,

Drag [Date] from a calendar table that has relationship to your table.