KNOWLEDGE BASE

Filtering Single Axis of Dual-Axis Chart


Published: 12 Nov 2014
Last Modified Date: 05 Oct 2018

Issue

When creating a dual-axis graph, the filter affects both graphs. There is no way to select which axis the filter affects. 

Environment

Tableau Desktop

Resolution

Option 1

The following instructions can be reviewed in the workbook attached below.
  1. Right-click on the data source and select Duplicate.
  2. Ensure that the dimension you want to filter is not being used to link the two data sources.
  3. Create the dual axis from the duplicated data source.
  4. Create a filter using the dimension from secondary data source. 
Note: This workaround will only work when a dimension is on the axis. This will not work with a measure on the axis. 

Option 2

Create a calculation that will return filtered data to be used on one axis. For more information, see Including Filters in Calculations Without Including them on the Filter Card
 
Did this article resolve the issue?