Last Modified Date: 20 Aug 2018
- Tableau Desktop
- Filter Actions
Option 1In some cases, it may be possible to convert measures into dimensions, using the level of detail (LOD) expression FIXED. For detailed instructions, please see Unable to Convert Measure to Dimension
Use parameters instead of Filter Actions. For more information, please see Use Parameters to Make Views More Interactive
Pivot the measures. For some data sources, it may be possible to pivot the data in Tableau Desktop. See Pivot Data from Columns to Rows
Option 4Join to a list of the measure names on join calculations of 1=1, which will duplicate every measure name for every record in the database. This option is demonstrated in the workbook in the right-hand pane of this page.
Note, join calculations are a new feature added in Tableau Desktop 10.2. For more information, please see Use calculations to resolve mismatches between fields in a join
CauseThe ability to create an Action that filters a target sheet based on a measure value is not currently built into the product.
Additional InformationTo voice your support for the inclusion of this enhancement in a future product release, add your vote to the following Community Idea: Filter Actions for Aggregate Measures
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials