Since a few years ago, i read several queries in this community about the possibility to have the option to sort dropdown list in multi-select filter. Currently, there is no option for developer to change the default sort which is provided in lexicographical order. Would it be possible now or soon to sort it in numerical order ?
Hi @francislau
Welcome to the QuickSight community!
Dropdown values are sorted in ascending order by default. It looks like you’re trying to sort a text field that contains kW. A simple workaround is to add numbers in front of the values to force a custom sort order, or remove the kW suffix so that the values sort correctly in ascending order.
1 Like
thank you. I followed your recommendation by just removing the kW suffix. The problem is solved.