# Order BY Date field KIBANA Lens visualization ordered by alphabetically

**URL:** https://discuss.elastic.co/t/order-by-date-field-kibana-lens-visualization-ordered-by-alphabetically/327523
**Category:** Kibana
**Tags:** lens
**Created:** [March 13, 2023, 6:16am UTC](https://discuss.elastic.co/t/order-by-date-field-kibana-lens-visualization-ordered-by-alphabetically/327523 "2023-03-13T06:16:30Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![vikram\_singh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vikram_singh/32/66490_2.png) [@vikram\_singh](https://discuss.elastic.co/u/vikram_singh)
#### Post date: [March 13, 2023, 6:16am UTC](https://discuss.elastic.co/t/order-by-date-field-kibana-lens-visualization-ordered-by-alphabetically/327523/1 "2023-03-13T06:16:30Z")

</div>

Hi,

I created a lens visualization in Kibana. I visualize data in tabular form like excel. When I set order on a date type field (date format like March-2023) it is not showed in correct order.  
Like Jan-2023, Feb-2023, Mar-2023, Apr-2023.  
It ordered it in alphabetically like Apr-2023, Feb-2023, Jan-2023, Mar-2023.

Have any solution for it or some trick to show data ordered by a date field in correctly.

Thanks in Advance,  
Vikram Singh

---

<div class="post-metadata">

### Author: ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)
#### Post date: [March 20, 2023, 9:18am UTC](https://discuss.elastic.co/t/order-by-date-field-kibana-lens-visualization-ordered-by-alphabetically/327523/2 "2023-03-20T09:18:02Z")

</div>

Hi @vikram_singh

if your rows dimension is a date histogram then it should already be sorted correctly (as it inherits the data order from ES response).  
Can you share the configuration of your Lens table, maybe I'm missing something.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 17, 2023, 9:19am UTC](https://discuss.elastic.co/t/order-by-date-field-kibana-lens-visualization-ordered-by-alphabetically/327523/3 "2023-04-17T09:19:03Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.