I have created MMM YYYY & YYYY MMM calculated columns. I am not able to sort this values in the filter. Help me out here.
My client want to have values in filter like "‘Jan 2025, Feb 2025” or “2025 Jan, 2025 Feb”.
Point 1 & 2 : Not able to get values like sorting order.
Point 3 is also not coming from old to new MonthYear wise.
Is this possible? OR future request.
Note: But It can be done in the visual charts level.
By default, Quick Sight sorts filter values in ascending alphanumeric order when the field is a string. This means filters with month-year formats like “Jan 2025” or “2025 Jan” will be sorted alphabetically, not chronologically. Numeric fields, on the other hand, are sorted numerically by default.
Workaround - To achieve chronological sorting in filter controls, create separate filters for Year (e.g., 2025) and the dependent filter Month (e.g., 01-Jan, 02-Feb, etc.). This way, selecting a year will show months sorted chronologically in the filter, providing the desired order for month and year selections.
I will mark this as a feature request to promote visibility to the support team. While Amazon does not disclose their current roadmap or timelines on additional features, you can keep an eye on the ‘What’s New’ tab in the community for updates that have been made.
It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.
If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.
Thank you!
Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.
Thank you!
