Line Chart dots

[atiyah]

Hi, 

Does anyone know how to connect the line graph dots like in the Picture 2?

I cant find a way how connect the line if the previous/next month have nil data. 

For example in Picture 1: 2016 Sep=1; Oct= nil data; Nov=3, the line only connect if there is a data on each month.

Picture1 (Power Bi):                                                                                Picture 2 (Power Pivot): 

                   

[Anonymous · Accepted solution]

Go to Edit Query, check if column for generating the line graph contains null value. If it is, replace the null value with 0. Then you should get the chart as you want.

Below is an example for your reference.

[atiyah]

Thank you so much Jessica Seiya!

Really appreciate it. 

Now I know where is wrong.