Removing Values from Filters

Published: 22 Mar 2013
Last Modified Date: 14 May 2018


How to remove or hide a value, such as Null, from a filter. 


Tableau Desktop


To remove or hide the Null option from filters, use one of the following procedures. To hide another value, follow one of the below steps, using that value in place of Null.

Option 1: Create a set to exclude Null values from filters.

  1. Right-click a dimension and select Create > Set.
  2. Name the set.
  3. In the Select from List section on the General tab, select all values except the null value, and click OK.
  4. Drag the newly created set to the Filters shelf.

Option 2: Create a new dimension that filters out null values.

  1. Right-click a dimension and select Duplicate.
  2. Drag the original field to the Filters shelf and include all values.
  3. Right-click the dimension on the Filters shelf and select Show Filter.
  4. Open the drop-down menu in the upper right corner of the filter card and then select Only Relevant Values.
  5. Place the duplicate field on the Filters shelf, select all values except the null value, and click OK.
Note: The above solutions are for filters based on a dimension in a primary data source. If you are filtering on a dimension from a secondary data source, see Removing Null Values from Filters Based on Secondary Data Sources.

Additional Information

  • You can use the same process to exclude other values from filters.
  • The steps provided will exclude null values from the filter along with any other data that is associated with those records.
To view these steps in action, see the video below: 
Did this article resolve the issue?