KNOWLEDGE BASE

Removing Null Values from Filters


Published: 22 Mar 2013
Last Modified Date: 04 Oct 2017

Question

How to remove or hide the null values from filters.

Environment

Tableau Desktop

Answer

To remove or hide the Null option from filters, use one of the following procedures.

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 values 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 values, and then 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?