KNOWLEDGE BASE

Unable to Sort Quick Filters by Measure


Published: 14 May 2013
Last Modified Date: 10 Sep 2017

Issue

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

Environment

Tableau Desktop

Resolution

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. 
Did this article resolve the issue?