Hi,
I am creating a parameter-based filter for the Pay_Period column in Amazon QuickSight. The values are stored as text in the format Month Year (for example: August 2025, July 2025, November 2025, October 2025, September 2025).
I want the parameter dropdown to display these values in descending chronological order (for example: November 2025, October 2025, September 2025, August 2025, July 2025).
What is the best way to achieve this sorting in QuickSight?
Hi @Narayana1,
Unfortunately, there is no feature/capability currently available that allows you to change the order of a control’s values away from alphabetical.
The best work around in this scenario would likely be to use custom values with numbers in front:
Then you can either use a ‘contains’ filtering option or build a calculated field that determines what each control value equals.
One other trick you can use, however this is more useful in a scenario when you want one specific value to be first…if you put a space in front of the word, it will automatically place it first in line, but the value in your control will still look normal as if there’s no space.
Overall, this is a feature that I’ve seen a few users request and I agree that it would be extremely helpful if you were able to reorganize the values how you see fit. So I’ll mark this as a feature request to promote visibility to the support team.
Hi @Narayana1,
As I have already tagged this as a feature request and there has been no further discussion, I’ll go ahead and close this. If you have any additional questions, feel free to create a new post in the community.
Thank you