Graphs won't display all months in a year

[kinga]

I made a month and year column from my date column and made the below graph, however the data only goes back to August 2016 and runs through March 2017, causing some months to not show up in the graph. I would like the graph to display April, May, June, and July as blanks. Is this possible?

[MFelix]

Add a date table with a all dates and link it to your dats and then use the dste tables for the axis.

MFELIX

[kinga]

Thanks for the quick reply. I set up a date table and now I have the below, however the months are out of order. I tried to go to more options in the visual and use the sort feature but it won't sort it in the appropriate order. I also tried sorting in my date table - Month Names (January, February, etc.) by the month short name (1,2,etc.) and this doesn't work either. This second method has worked for me to sort a month filter.

[MFelix · Accepted solution]

Hi @kinga,

Use the date column and hierarchy option and select only the month, or else you will have a drill down chart.

Mfelix

[cboyapati]

Its working as excepted 

[kinga]

Hi MFelix - Thanks for your help. It is working for me now. I really appreciate it.