How to Show all Axis Values in a Tooltip in a Dual-Axis Chart

Published: 15 Aug 2023
Last Modified Date: 17 Aug 2023

Question

How to show all axis values in a tooltip with a dual-axis chart. The tooltip by default, will show only one axis value from a dual-axis chart. In addition, the Insert menu of the tooltip will not display the alternate axis for selection.

For example, the tooltip for SUM(Sales) axis will not show SUM(Profit) value by default which is the alternate axis value.

User-added image

Environment

Tableau Desktop

Answer

To display the value of the other axis not represented in the tooltip, add each other's values to the Tooltip on the Marks card.

Below is an example of how each value is displayed in the Tooltip for the dual axis chart of Sales and Profit.

1. Click on SUM(Sales) in the Marks card. The SUM(Sales) axis card will open.

　 User-added image

2. Add Profit from the Data pane to Tooltip on the SUM(Sales) axis card as SUM(Profit). Then, SUM(Profit) value displays in the Tooltip.

　 User-added image

3. Click on SUM(Profit) in the Marks card. The SUM(Profit) axis card will open.

　 User-added image

4. Add Sales from the Data pane to Tooltip on the SUM(Profit) axis card as SUM(Sales). Then, SUM(Sales) value displays in the Tooltip.

　 User-added image