Line graph, months names along the x-axis - sorted by month order - but how to keep as continuous?

[twofingertyper]

Hi all, 

I feel like I am missing something obvious here, but I have a line graph where I have months along the bottom (Jan, Feb, etc) this is drawn from a date table and then the sorting of these months is similarly managed by a column that has the sorting order in the same date table. 

All this is fine, but I cannot get the x-axis to stay as continuous (as opposed to categorical) which is occasionally a problem when a month has no value against it. 

Please tell me the obvious trick I am missing! 

[Ashish_Mathur · Accepted solution]

Hi,

If you wish to show months even if there is no value, then revise your measure to

Measure = coalesce([your measure],0)

Hope this helps.

[twofingertyper]

Thanks for this - will give it a go and mark as solution if it works for me. 

Have never used Coalesce before, so will be interesting to see if it works! 

[audreygerred]

Hi! Try putting the month nuimber in the x-axis instead of the month name. Continuous should work then. You can also put date in and have it work.

Month Number in x-axis:

Date in x-axis:

[twofingertyper]

Thanks - this works, but I really want to use the short month name.