# KPI Date fields sorting

**URL:** <https://community.amazonquick.com/t/kpi-date-fields-sorting/5789>\
**Category:** Q&A\
**Tags:** analysis, date, quick-sight\
**Created:** [September 2, 2022, 8:06am UTC](https://community.amazonquick.com/t/kpi-date-fields-sorting/5789 "2022-09-02T08:06:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![AnjanaShanmugam](https://avatars.discourse-cdn.com/v4/letter/a/c0e974/32.png) [@AnjanaShanmugam](https://community.amazonquick.com/u/AnjanaShanmugam)\
**Post date:** [September 2, 2022, 8:06am UTC](https://community.amazonquick.com/t/kpi-date-fields-sorting/5789/1 "2022-09-02T08:06:48Z")

</div>

Hi,  
I’ve a specific ask here on KPI’s.  
This is how the Quicksight KPI’s behave, it always takes Date from Descending order.  
 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/c/c056c3cd2368da9fe446d7d0e8cf7d3c0c3dd27c.png)  
But I would want to do the reverse here, it worked when I changed the sort and the problem here is the difference value it shows. expected is to subtract from the recent week to the previous week. there is no such option available. Any thoughts here.  
 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/0/0f5ee20e8302fd57368b0bae94ecf9fbde671aa5.png)

---

<div class="post-metadata">

**Author:** ![rajjaya](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/rajjaya/32/4534_2.png) [@rajjaya](https://community.amazonquick.com/u/rajjaya)\
**Post date:** [September 2, 2022, 8:16am UTC](https://community.amazonquick.com/t/kpi-date-fields-sorting/5789/2 "2022-09-02T08:16:54Z")

</div>

Hi @AnjanaShanmugam

Currently, this is the expected behavior. We have a product feature in place to support alignment options for dates and difference. However, we do not have an ETA on when this would be generally available.

---

<div class="post-metadata">

**Author:** ![GMG](https://avatars.discourse-cdn.com/v4/letter/g/977dab/32.png) [@GMG](https://community.amazonquick.com/u/GMG)\
**Post date:** [July 5, 2023, 8:58pm UTC](https://community.amazonquick.com/t/kpi-date-fields-sorting/5789/3 "2023-07-05T20:58:50Z")

</div>

Hi @rajjaya,

Is there any update on this subject?

Do you already have an ETA for the availability of this feature?

Kind regards,

Gonçalo
