Allow customization of dashboard filter sort order when values come from connected fields or another question

[megansmcguire]

When I set up a dashboard filter, I rarely want to maintain a manual list of options. Most recently, I've been configuring a dashboard filter based on our fiscal quarter name (displayed as a category from our DB--does not play well with date functions as it's offset by a month and calendar year (we just started Q2 FY25). When I set this up using the connected fields or using a question to generate the list (basically `select distinct FY-FQ from dates order by 1 desc), the sort order is automatically alphabetical, ascending. The only workaround I've found is to manually maintain the list. Ideally, I'd like to be able to customize the sort order for the dashboard filter drop down list--just an option on whether to sort Asc or Desc would make my dashboard user experience better.