How can I make my Grafana charts start from the first of the month when I select an interval of 1M?

All my time-based Grafana charts exhibit this “issue”. If I select a 1M interval, each data point (e.g. each bar in a bar chart) starts from a seemingly random day of the month, like the 10th of December in the screenshot below.

Even I set my time range to be 20xx-01-01 - 2020-12-31 .

How can I force it to show one bar per calendar month instead?


the query can be longer
in the display options say
fro now-30d or now-1m or from the 1st of a specific month

Sorry, I don’t understand what you mean. Could you please elaborate? Thanks!

in the top right of the window you can select the range and there you put in the formula

But it’s already from the 1st of a specific month.

yes you say now - 30d

But I don’t want a range that starts from now-30d. I want the range in the screenshot: from 2019-01-01 to 2020-12-31, and I want each bar to be a calendar month (from the 1st to the 28th, 29th, 30th or 31st, depending on the month).

Right now even if I select Min interval = 1M, I’m forced into a 30d interval which means that each bar doesn’t start from the 1st of the month but it shifts with time.

Did I explain it better now? Because I feel like you misinterpreted my question.

Thanks again for your time!

ok you can say from 2019 1 1 to 2020 12 31 and leave the query options out