Bar Chart set to show last 12 months, is only showing 11 months of data as the first value is zero.
I have a Bar Chart with the last FY worth of data up to 30 June 2021. I'd like the chart to show the last 12 months of data, however, it is only showing the last 11.
There is no data in July 2020, which is why I'm guessing it's not showing the column. The nature of the data is that there will be no entries if there were no data points, so I can't just add a data point that says 0. I need it to show a zero value for July. Is that possible?