Specifying Sort Order of Items in Quick Filters

Issue

When manually sorting a specific measure in filter, only the items in the view are sorted and the items into the filter list are not sorted.

Environment

Tableau Desktop

Resolution

While this feature has not been implemented in Tableau at the moment, as workaround the following options may help. These options have been added to a sample workbook and attached to article.
The desired sort in sample workbook for "category" is "a,c,b,d" with "rank" values "1,2,3,4".

Step 1 - Create calculated fields

Create a calculated field that concatenates the sorted measure with filter field which will force the sort:

Select Analysis > Create calculated field
Name the calculated field "_rank_category"
Enter the following formula and click OK:
```
STR([rank]) +' - ' + [category]
```

Step 2 - Build the view

Follow the steps below to sort "category" field based on "rank" field:

Add “category” to “Rows” and “amount” to “Text” in Marks
Add “category” to “Filters” and “Show Filter”
Select “Sort” for category” in “Filters and select below:
1. Sort Order: Ascending
2. Sort by: Field: rank – Aggregation: Minimum
Add "_rank_category" to filter