Loading

Specifying Sort Order of Items in Quick Filters

Data pubblicazione: Apr 30, 2025
Descrizione
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. 

Cause

The ability to sort quick filter items by a specific measure is not currently a feature in Tableau Desktop.
Risoluzione
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:
  1. Select Analysis > Create calculated field
  2. Name the calculated field "_rank_category"
  3. 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:
  1. Add “category” to “Rows” and “amount” to “Text” in Marks
  2. Add “category” to “Filters” and “Show Filter”
  3. Select “Sort” for category” in “Filters and select below:
    1. Sort Order: Ascending
    2. Sort by: Field: rank – Aggregation: Minimum
  4. Add "_rank_category" to filter
This setting sorts the view based on rank value.
Risorse aggiuntive

Highlight Toolbar Button
Can I sort the entries on a Quick Filter card in descending order?


To voice your support for the inclusion of this feature in a future product release, add your vote to the following Community Idea:

Numero articolo Knowledge

001472873

Allegati

SortingFilterItems.twbx

12 KB

 
Caricamento
Salesforce Help | Article