Menu
    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: 06 Oct 2018

    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?    
    PRINT THIS PAGE
    Related Links
    Filter Actions
    Attachments

    All Support

    SUPPORT BY PRODUCT
    TOOLS & DOWNLOADS
    INFORMATION
    ASSISTANCE