KNOWLEDGE BASE

Unable to Create Dual Axis Chart with Multiple Measures on both Axis


Published: 14 Feb 2014
Last Modified Date: 20 Oct 2021

Issue

Unable to create a single chart showing more than one measure on both axes of a dual axis chart like below.

User-added image
 

Environment

  • Tableau Desktop

Resolution

As a possible workaround, use the pivot function to convert several measures into one measure and add this measure in the view with dual-axis.

Please note that this workaround has some restrictions:
1. Pivot could not apply to the calculation fields.
2. Other measures after pivoting need to be revised. (e.g. divided by the number of measures that are used in pivoting)

See the attached workbook and the video for details. 
 

Cause

The ability to show more than one measure on both axes of a dual axis chart is not currently built into the product.
Did this article resolve the issue?