To format zeroes (0) in Tableau to something else, such as a dash (-) for example, is simple using standard formatting techniques. For example use this technique to not show zero values, simply by formatting zero as a zero length string (“”).

In the standard Tableau number formatting there’s a Custom option. It is here Tableau will allow us to format zero values.

The structure of the Custom number format is:


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 ‘-‘:


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: