KNOWLEDGE BASE

How To Display The Total Of Two Different Measures Represented On A Dual Axis


Published: 23 Mar 2020
Last Modified Date: 24 Mar 2020

Question

How to display the total of two different measures represented on a dual axis

Environment

  • Tableau Desktop

Answer

1. Create the dual axis chart with two measures on the view like below:
User-added image
2. Create a calculated field Combined like below combining the two measures:
SUM([Sales])+MIN([second])
3. Drag Combined to Detail on Marks Card for ALL 
User-added image

4. Right Click on the axis an add reference line like below:
User-added image
5. Go to Format -> Reference Lines 
Under Reference line label, change the format as below:
User-added image
Did this article resolve the issue?