Tableau format zero values

To format zeroes (0) to something else, such as a dash (-) for example, is simple using standard formatting techniques.

In the number formatting there’s a Custom option.

The syntax of this can be used to change 0 values to anything we want. The structure of the Custom number format is:

Positive;Negative;Zero

Enter the following in the Custom format to display all positive and negative values to 1 decimal place and convert all 0s to become a ‘-‘:

#,##0.0;-#,##0.0;

You can actually change zero values to anything you want using this technique. The Custom format #,##0.0;-#,##0.0; Zero Value gives the following:

2018-03-05T21:21:22+00:00 March 5th, 2018|Tableau, Tableau Basic|

Leave A Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.