Sorting Quicksight controls in descending order

Question & Answer
, ,
1

Hi,
I am working on a dashboard that is used to visualize and compare reports. Each report has multiple revisions, and is tracked following the naming convention below:
ReportName_ReportIdentifier1_ReportIdentifier2 (RevX.Y)

Example report names:
TestReport_ID1_ID2 (Rev1.45)
TestReport_ID1_ID2 (Rev1.48)
TestReport_ID1_ID2 (Rev1.50)
TestReport_ID1_ID2 (Rev1.55)

Question: We are using the report names in dropdown controls, and the default sorting is in ascending order as shown above. Can we sort descending so the latest/highest number revision report is displayed on top?

1 Like
2

Hi @pattsai ,

It is currently not possible to customize the order of values in a filter dropdown in Amazon QuickSight. The values are sorted alphabetically by default. Some workarounds include adding numbers in front of the values to force a custom order. Refer Issue on Dropdown parameter - #2 by royyung.

In your case, you can re-order the dropdown by renaming the reports ( add numbers in front of it) to display the order of your choice.