Line graph showing all months in X axis even when data is not present

[Jay2022]

I have some data which consists of dates and %s at the moment it shows the percentage increase in a line graph however the X axis is not showing every month only the month where there is data 

eg Nov 80% then it jumps to march and then may may may 

what i want it to do is to show nov, dec, jan with the % remaining the same until the change occurs any help greatly appreciated 

[Jay2022]

its ok though have ysed a seperate dates table works great now thank you 

[Jay2022]

Thank you i have done that but it still doesn't make no difference i think the problem is i don't have those months presented in the data at all 

[Tahreem24]

@Jay2022 No problem, in such case, create one Calendar table as below:

Calendar = CALENDARAUTO()

Then make a relationship between this Calendar's Date column with table's ShipDate, And use the Calendar's Date column on your chart.

This may solve your issue.

[Tahreem24 · Accepted solution]

@Jay2022  Try enabling the "Show items with no data".