Unable to Create Dual Axis Chart with Multiple Measures on both Axis
Published: 14 Feb 2014 Last Modified Date: 20 Oct 2021
Unable to create a single chart showing more than one measure on both axes of a dual axis chart like below.
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.
The ability to show more than one measure on both axes of a dual axis chart is not currently built into the product.