Unable to Sort Quick Filters by Measure

Published: 14 May 2013
Last Modified Date: 23 Apr 2020


It is not possible to sort a quick filter by measure.


Tableau Desktop


Option 1: Manually sort the filter

  1. Right-click the dimension in the Data pane and then select Default Properties > Sort.
  2. Select Manual, adjust the sort order, and then click OK. For more information, see Setting a Default Sort Order.

Option 2: Use a crosstab for filtering on a dashboard. 

See attached packaged workbook for an example.
  1. Create a new worksheet.
  2. Place the dimension you would like to filter by on Rows. 
  3. Add the measure you would like to sort the filter by on Rows, to the left of the dimension.
  4. Sort the view as desired. 
  5. Add the two worksheets to a dashboard.
  6. Click the funnel icon (Use as Filter) on the new worksheet to use it as a filter. 


The ability to sort quick filters by a specific measure is not currently built in Tableau Desktop.
Did this article resolve the issue?