KNOWLEDGE BASE

Warning "Missing fields" When Creating Filter Action Or Target Worksheet Does not Change After Triggering Action Filter


Published: 25 Apr 2014
Last Modified Date: 15 Jun 2017

Issue

When creating a Filter Action with "Selected Fields", then the following warning might display:
 
Missing fields on <source sheet name>

Or

When a Filter Action has been created with the default "All Fields" selected for Target Filters,  and the Filter Action is triggered, the target worksheet does not change.

 

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.

Additional Information

Dimensions on the Filters shelf of the source sheet or aggregated dimensions (ATTR(), MIN(), etc.) are not considered as target fields. 
 
Did this article resolve the issue?