Grafana&Prometheus Daily

Hi,

I have a daily counter which I store in Prometheus. Managements now wants a column chart/day. However when I select the time series, set the interval to 1 day in Grafana, the timestamp on the X-axis shows as midnight next day (data for 03/03 shows up at the tick mark of 04/03 00:00) which throws off users when looking at the graph.

I could make use of the X-axis series-mode if I had a series/day. However afaik I can’t do such a splitting at the data source level and the transforms in Grafana usually go into the merging/combining/joining way.

Anyone an idea besides me inserting another data source between Grafana and prometheus which does this splitting?