# Graph x axis date format

**URL:** <https://community.grafana.com/t/graph-x-axis-date-format/27079>\
**Category:** Grafana\
**Created:** [March 10, 2020, 11:44am UTC](https://community.grafana.com/t/graph-x-axis-date-format/27079 "2020-03-10T11:44:16Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![gegiantas](https://avatars.discourse-cdn.com/v4/letter/g/90ced4/32.png) [@gegiantas](https://community.grafana.com/u/gegiantas)\
**Post date:** [March 10, 2020, 11:44am UTC](https://community.grafana.com/t/graph-x-axis-date-format/27079/1 "2020-03-10T11:44:16Z")

</div>

Hi everyone,  
Is there a way to customize the x axis date format?  
I would like to have the format ‘dd/mm’ instead of ‘mm/dd’.  
Moreover, my query returns the last 30 days and some data for each one of them but the graph  
shows the results in x -axis every 3 days.

Any help would be appreciated

---

<div class="post-metadata">

**Author:** ![castillo92](https://avatars.discourse-cdn.com/v4/letter/c/c67d28/32.png) [@castillo92](https://community.grafana.com/u/castillo92)\
**Post date:** [March 10, 2020, 12:43pm UTC](https://community.grafana.com/t/graph-x-axis-date-format/27079/2 "2020-03-10T12:43:30Z")

</div>

I do not know about the format ‘dd/mm’, but I would like to know it.

The other fact, to see everyday in a graph with 30days you should `GROUP BY time(1d)` instead of `GROUP BY time($__interval)`

---

<div class="post-metadata">

**Author:** ![gegiantas](https://avatars.discourse-cdn.com/v4/letter/g/90ced4/32.png) [@gegiantas](https://community.grafana.com/u/gegiantas)\
**Post date:** [March 10, 2020, 1:40pm UTC](https://community.grafana.com/t/graph-x-axis-date-format/27079/3 "2020-03-10T13:40:19Z")

</div>

> [@castillo92](#):
>
> $\_\_interval

The results returned by my query are grouped by 1 day… I dont know if you mean something different

---

<div class="post-metadata">

**Author:** ![castillo92](https://avatars.discourse-cdn.com/v4/letter/c/c67d28/32.png) [@castillo92](https://community.grafana.com/u/castillo92)\
**Post date:** [March 10, 2020, 2:43pm UTC](https://community.grafana.com/t/graph-x-axis-date-format/27079/4 "2020-03-10T14:43:55Z")

</div>

> [@gegiantas](#):
>
> an something dif

Could you paste here your query? To know if there is a mistake with the query or the graph

---

<div class="post-metadata">

**Author:** ![gegiantas](https://avatars.discourse-cdn.com/v4/letter/g/90ced4/32.png) [@gegiantas](https://community.grafana.com/u/gegiantas)\
**Post date:** [March 10, 2020, 2:57pm UTC](https://community.grafana.com/t/graph-x-axis-date-format/27079/5 "2020-03-10T14:57:43Z")

</div>

My query looks like  
select date1 as time,  
sum(x)  
from a  
group by date1

and returns 30 rows each one for a day

---

<div class="post-metadata">

**Author:** ![castillo92](https://avatars.discourse-cdn.com/v4/letter/c/c67d28/32.png) [@castillo92](https://community.grafana.com/u/castillo92)\
**Post date:** [March 11, 2020, 7:55am UTC](https://community.grafana.com/t/graph-x-axis-date-format/27079/6 "2020-03-11T07:55:52Z")

</div>

What is the value of “date1” inside GROUP BY clause?

---

<div class="post-metadata">

**Author:** ![gegiantas](https://avatars.discourse-cdn.com/v4/letter/g/90ced4/32.png) [@gegiantas](https://community.grafana.com/u/gegiantas)\
**Post date:** [March 11, 2020, 9:20am UTC](https://community.grafana.com/t/graph-x-axis-date-format/27079/7 "2020-03-11T09:20:40Z")

</div>

Its a date datatype.