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