I have a control on an analysis, which is parameter based and linked to a dataset field. Specifically, my dataset field is a set of strings representing different number ranges (i.e., 1 - 15, 16 - 25, … , 1001 - 1100, etc.). Here’s a screenshot of what it currently looks like.
QuickSight automatically applies alphabetized ordering to all of my controls; for this control, you can see that alpha-ordering doesn’t really make sense. My question is: can I apply custom ordering to my controls? I’ve noticed that QuickSight always alphabetizes the control options, even when I put in a finite list of options (instead of linking to a database field). Is there any way to override this behavior?
Thank you!
Hello @ltaylor, I hope this message finds you well. 
I have done something similar before, which involved creating a calculated field to transform these strings by order, like:
A) 1-15
B) 16-30
or something like:
00.1-15
01.16-30
Let me know if this works for you.
Thank you for the response! That’s ultimately the only way to go at this point, I think so too.
The trouble I have now is that I also need to connect this parameter control to a chart navigation action, so now my data isn’t lining up with what’s displaying on the chart (for my chart axis, it doesn’t make sense to display “01. 1 - 15”, it makes sense to display “1 - 15”, thus the mismatch).
Anyway, it’d sure be nice if this were a QuickSight feature (hint hint QuickSight team). But for now I’m going to mark your answer as the “solution”. Thank you again!
1 Like
