How to format X axis label

[mrburns]

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:

time range 2 days:

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?

[mrburns]

Hi - is here any solution available please?

[mrburns]

Hi,

may someone from Grafana team can assist here please?

[ldrascic]

Hi @mrburns,
Take a look at this post:

How to filter day, moth, year in axis

Hi @nvbgm, Inspired by topic How can I change graph X-axis to show days of the week(Monday, Tuesday, Wednesday etc) here is a solution that works with bar chart only. Create a query and assign override for Time field. For Add override property choose Standard options > Unit and set it to time: DD/MM. The output format will be <day_number>/<month_number> like on picture. [Grafana override time format] Note: Data is grouped by day GROUP BY time(1d). If you want to show all dates (a.k.a. bar l…

Links:

• Grafana | Custom units
• Momentjs | Date format

 

Best regards,
ldrascic

[martinklimke]

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.

[ldrascic]

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

 

Best regards,
Ldrascic

[noplayback]

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