Bar chart min and max value

I have an object class called Invoice history that consists of the properties Amount (float) and Completed date (DateTime). I have plotted Invoice history in a bar chart where data is grouped by month and the amount is summed. A filter ensures that only one year at a time is shown. Is there a way I can make the bar chart show all the months of the year, even though some months do not contain data?

In the screenshot here I would for example like to see November and December:
image

I tried adding an app variable that finds the last day of the current year as input for max value on the X-axis (and same method with min), but the chart then shows numbers in stead of month names and one month too many.

image

Hi!

I believe you are pretty close here!

Try the following: Category Axis (X): Choose Axis type = Datetime, and then set the Min and/or Max value to a datetime (e.g. using Now.valueprocessor(endofyear), Now.valueprocessor(to months back, startofmonth))