Line and Clustered Column chart - No Continued line

[rocky09]

See below image, I am not sure, why the line is continued, it breaks on August Month and again started in December. Can any one advise or share the tips, how to get rid of this issue, I would like to have a continued line.

[v-yuta-msft]

Hi rocky09,

Based on the chart you provided, values of [No. of Errors] are null in several months, right?

To achieve a continued line, you should replace null with 0 in Query Editor.

 

The result is like below and you can refer to PBIX file here:

https://www.dropbox.com/s/uq55jklv0b0oi3y/For%20rocky09.pbix?dl=0

 

Best Regards,

Jimmy Tao

[rocky09]

@v-yuta-msft

Thank you so much for your time and reply.

1. Actually, I have date table and data table.

2. The Date table is from January 1, 2017 to today.

3. The Data table may not have entries for a month.

So, When I use Date from Data table as X-axis and Data values from Data Table. It seems, the line breaks when there is no data for a month.