Adjust date / time format of x-axis of time series visualization

Grafana Time Series Panel
1

Hi experts,
I would like to adjust the X-Axis of Time Series visualizations to a format that is used here (Germany).
It should be the easiest thing of the world and I feel a bit stupid, but I can not manage and can not find much information about it. Some entries here in the forum suggests that it is not possible at all to adjust the format?! It’s hard for me to believe with such an elaborated system as Grafana!

What I have tried is to add an override
grafik

But whatever I put behind “time:” - it has no impact on the format of the X-axis.

grafik
grafik798×56 3.01 KB

I’m using Grafana version 11.1.1. my data source (if that is of any relevance) is InfluxDB.

Any advice?
Thanks!

2

Hmm, either this question is too difficult or so obvious that nobody wants to invest time in answering it.

Maybe I wasn’t able to clearly state my question? Please let me know if anything is unclear and I will try to clarify it!

Christian

1 Like
3

Hi @info90f4 ,

I cannot confirm 100% (due to using an older version G9.5)
but don’t think it is possible to alter the x-as using the ‘Time Series’ panel. (I can remember there have been similar topics with this question). I’m only able to alter the ‘tooltip’ (format) with the override.

image
image1109×573 53.1 KB

image
image1120×304 19.9 KB

I can confirm it works for ‘Bar Chart’

image
image1220×295 33 KB

unf. some ‘easy’ expected things have not been implemented in Grafana yet.

1 Like
4

if you are feeling adventurous you could use business chart plugin and the options are endless

image
image1469×336 75 KB

5

Finally I found a solution.

In the grafana.ini (actually I use environment variables, since I start Grafana in a docker container), there is a section called date_formats. And - believe it or not - here you can set date formats for the panels.
There are several format settings for different time intervals, but for me it worked when I set use_browser_locale to true (was on false). After that (and restarting the Grafana instance) all x-axis captions in the time series where on the correct, in my case German, date / time format!

2 Likes
6

Hello,

I have the same issue and was wondering if you could share the proper environment variables you use.

Many thanks in advance.

7

Hi @reinhardgut,

sorry for the late reply!

Here is a small piece of my docker-compose.yml to start Grafana (together with InfluxDB and Telegraf).

grafana:
        image: grafana/grafana
        container_name: grafana
        restart: always
        environment:
            - GF_DATE_FORMATS_USE_BROWSER_LOCALE=true
            ...

That was all that was needed for me to have properly formatted date and time captions.