How to format X axis label

Hi,

I use Grafana v9.3.2 on a Windows Server 2016.
I have a barchart but problems with the X-axis label:

time range 7 days:
XAxisLabel1

time range 2 days:
XAxisLabel2

I always want to show the date in format like:

DD.MM.YYYY

independent from the choosen range.
I looked here in the forum but could not find any solution.
I found only that one can edit the general date format inside defaults.ini.
But this does not solve my problem.

So how please can I format the x-axis labes to my needs?

Hi - is here any solution available please?

Hi,

may someone from Grafana team can assist here please?

Hi @mrburns,
Take a look at this post:

Links:

 

Best regards,
ldrascic

1 Like

The word “solution” is only a terrible workaround which is only working in 5 % of the cases.

This program is so super complicated to use. The UI is so really badly done. It is extremely frustrating how much time I am loosing fiddling around in some settings in some config files.

The UI needs a totally new approach from the user’s point of view but not from the developer’s perspective who only uses the command line and never uses the Web UI.

1 Like

Hi @martinklimke,
Date formatting now works on time series too! Tested on Grafana 10.1.5.

 

Best regards,
Ldrascic

1 Like

Solution does not work for me…

Trying to do similar stuff… have a time series, shows values as bars.
Using the override-trick as shown here does not do any change to the timeformat on the x axis, sticks to default. Would like to have something like “DD HH:MM”, but whatever i choose, there is no difference.
The query to create the data:

SELECT
ts as time,
price/1000*100 as “Preis in Cent”
FROM misc.aWATTar
WHERE ts >= $__unixEpochFrom() * 1000 AND ts <= $__unixEpochTo() * 1000
ORDER BY ts ASC

Is there an update on this?

It would be really helpful to be able to easily switch the display of date/time on the X-Axis to a user defined format

1 Like

Still not working.

1 Like

+1 for this request, it’d be really useful

2 Likes