KNOWLEDGE BASE

Displaying Different Number Format in the Axis and Tooltip


Published: 20 Sep 2013
Last Modified Date: 13 Nov 2017

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

  1. In the Data pane, right-click the field to be formatted and select Duplicate
  2. Place the original field on the Rows or Columns shelf.
  3. Place the copied field on the Text shelf.
  4. Navigate to Worksheet > Tooltip.
  5. Edit the tooltip to display the copied field in the Tooltip dialog box.
  6. Right-click the view and select Format
  7. Use the Fields drop-down menu in the top right of the Format pane to select the desired field.
  8. Format the original field in the Axis tab to display no decimals.
  9. 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.
Did this article resolve the issue?