Displaying Different Number Format in the Axis and Tooltip

Published: 20 Sep 2013
Last Modified Date: 30 Nov 2023

Question

How to display different number formats in the axis and the tooltip. For example, displaying no decimal places in the axis and two decimal places in the tooltip.

Environment

Tableau Desktop

Answer

In the Data pane, right-click the field to be formatted and select Duplicate.
Place the original field on the Rows or Columns shelf.
Place the copied field on the Text shelf.
Navigate to Worksheet > Tooltip.
Edit the tooltip to display the copied field in the Tooltip dialog box.
Right-click the view and select Format.
Use the Fields drop-down menu in the top right of the Format pane to select the desired field.
Format the original field in the Axis tab to display no decimals.
Format the copied field in the Pane tab to display two decimals.

To view these steps in action, see the video below:

Additional Information

In Tableau Desktop, the ability to display different axis and tooltip formats is currently not built in the product. To voice your support for the inclusion of this feature request in a future product release, add your vote to the following Community Idea: Separate axis and tooltip formats.