KNOWLEDGE BASE

Warning "Missing fields" Creating Filter Action


Published: 25 Apr 2014
Last Modified Date: 21 Oct 2016

Issue

When you try to create a filter action, the following warning might display:
 
Missing fields on <source sheet name>

Environment

Tableau Desktop

Resolution

Option 1: If the field used as a target filter is a dimension not present in the source worksheet

  1. In Tableau Desktop, open the dashboard.
  2. Select Dashboard > Actions.
  3. Select the filter action, and then click Edit.
  4. In the Edit Filter Action dialog box, hover over the "Missing fields" warning to identify which fields are missing. 
    A caption will appear listing all the missing fields. Click OK.
  5. Navigate to the source sheet, and drag the missing fields to the view.
Note: If you do not want to show the missing field in the view, placing the field on Detail will sometimes allow you to still filter on the target field without changing the appearance of the view.

Option 2: If a measure is used as a source field in the filter action

Convert the measure to a dimension. For more information, see Converting Measures to Dimensions.
 

Cause

Option 1

The source field used in the target filter is not used in the source worksheet.

Option 2

Only dimensions can be used as the source field in target filters.
Did this article resolve the issue?