# How to change the order of the heat map vertical axis

**URL:** <https://discuss.elastic.co/t/how-to-change-the-order-of-the-heat-map-vertical-axis/368254>\
**Category:** Kibana\
**Created:** [October 4, 2024, 1:51pm UTC](https://discuss.elastic.co/t/how-to-change-the-order-of-the-heat-map-vertical-axis/368254 "2024-10-04T13:51:32Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![maaa](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@maaa](https://discuss.elastic.co/u/maaa)\
**Post date:** [October 4, 2024, 1:51pm UTC](https://discuss.elastic.co/t/how-to-change-the-order-of-the-heat-map-vertical-axis/368254/1 "2024-10-04T13:51:32Z")

</div>

When using the visualization type HeatMap, the order of the vertical axis is descending.  
How can I change it to ascending order?  
I want to set the origin coordinate to 0.

---

<div class="post-metadata">

**Author:** ![Alex\_Salgado-Elastic](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alex_salgado-elastic/32/103081_2.png) [@Alex\_Salgado-Elastic](https://discuss.elastic.co/u/Alex_Salgado-Elastic)\
**Post date:** [October 4, 2024, 2:13pm UTC](https://discuss.elastic.co/t/how-to-change-the-order-of-the-heat-map-vertical-axis/368254/2 "2024-10-04T14:13:26Z")

</div>

Hi @maaa , welcome to our commuity.

Please, see if this link helps you: [Heatmap Y-Axis reversed - #3 by mpitt](https://discuss.elastic.co/t/heatmap-y-axis-reversed/228894/3)

---

<div class="post-metadata">

**Author:** ![maaa](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@maaa](https://discuss.elastic.co/u/maaa)\
**Post date:** [October 4, 2024, 3:36pm UTC](https://discuss.elastic.co/t/how-to-change-the-order-of-the-heat-map-vertical-axis/368254/3 "2024-10-04T15:36:00Z")

</div>

![image](https://us1.discourse-cdn.com/elastic/original/3X/8/c/8cd7c902d4e971be47b5f9bc3ec150853ee94e71.png)

Thank you for your reply.  
I'm sorry I'm a beginner.

I don't know how to add codes.  
The screen I'm currently using for Elastic doesn't have a place to add codes or set axes.  
Where should I add codes?

---

<div class="post-metadata">

**Author:** ![Alex\_Salgado-Elastic](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alex_salgado-elastic/32/103081_2.png) [@Alex\_Salgado-Elastic](https://discuss.elastic.co/u/Alex_Salgado-Elastic)\
**Post date:** [October 6, 2024, 11:33am UTC](https://discuss.elastic.co/t/how-to-change-the-order-of-the-heat-map-vertical-axis/368254/4 "2024-10-06T11:33:22Z")

</div>

Hi @maaa ,

I found another article that could help you on that: [Using Elasticsearch Query Language (ES|QL) for statistical analysis — Search Labs](https://www.elastic.co/search-labs/blog/elasticsearch-query-language-esql-statistical-analysis)
