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, QuickSight 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.
