KNOWLEDGE BASE

Filtering Single Axis of Dual-Axis Chart


Published: 12 Nov 2014
Last Modified Date: 10 May 2016

Issue

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

Environment

Tableau Desktop

Resolution

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. 
Did this article resolve the issue?