Change dashboard date format

“I have a Grafana dashboard with time series charts, and currently, the date format is set as DD-MM-YYYY HH:mm:ss. I would like to know if it’s possible to change this format, but I’ve already edited the grafana.ini file, which changes the format for the entire Grafana system. Is it possible to change the date format for just this dashboard?”

I know I have multiple formats but how can I set the timeseries to use for example interval_year.

My current query

SELECT STR_TO_DATE(CONCAT(year, '-01-01'), '%Y-%m-%d') AS time, quantity AS value
FROM net4co2.annual_green_house_gas_data
WHERE category = '$category'
ORDER BY time;

Current chart time display

If I changed the default system format it will be okay, but I don’t want to change all system to that format

After editing your grafana.ini, did you restart grafana?

Also what is your data source? mysql, postgres?

Also

Yes if I edit the config that I told you I got only the year on display and that’s good. But then all system has date time format with only YYYY.

I’m using MySQL for database.

1 Like

Hi @goncalosimoesbastos ,
You can use define custom unit, for example time: DD.MM.YYYY , for Time field in override section:

 

See next post for more information:

 

Best regards,
ldrascic

1 Like

Thanks, works perfectly for the format time. Great job man