Bar chart date format

[gurusolve4u]

Hi Team,
Am using Grafana 9.4.2, where i have configured the Bar chart. On my X-Axis only the time time are display, I want the Date to be displayed in “DD-MM-YYYY”
I have tried like overrides and changing the format all the way, its not working out,
the below is my query,
sum by (projectName) (count_over_time({k8sCluster=“$cluster”, namespace=“$namespace”, app=“$workload”} | json | projectName != “” [$__interval]))
done all posible changes, but nothing workout,
Thanks in advance,
Guru

[sowdenraymond]

can you please show a table view of your data?

[gurusolve4u]

Hi Raymond,
I have resolved the issue, Thanks for your time

[ebabeshko]

@gurusolve4u

I have resolved the issue

It would be nice to share your experience, so as it could be reused by community

[yosiasz]

plagiarized from @grant2 post here

How can I change graph X-axis to show days of the week(Monday, Tuesday, Wednesday etc)

Hi @nivekc Try the override of the units to be time:dd ( you will have to type it in, as it is not in the list of choices). [image] Unfortunately, I have found it only works (for me) on tables. Maybe one of the Grafana staff can comment on if it should not work on other visualizations.