KNOWLEDGE BASE

5-Digit Custom Format Applied to 7-digit Japanese Postal Code


Published: 21 Aug 2018
Last Modified Date: 30 Aug 2018

Issue

When applying numeric data as a Postal Code, the custom format of the default number format is automatically set as five digits "00000."  However, Japanese Postal Codes are seven digits "0000000" and can begin with 0.  

A postal code that begins with a 0 results in NULL, and is omitted when handled as numeric.

Environment

  • Tableau Desktop 2018.2 

Resolution


By following the below steps, this will force the Postal Code to display 7 digits:
  1. Right Click on Postal Code in the Dimension Section of the Data Pane
  2. Select the Default Properties > Number Format 
  3. Select the Custom and then insert '0000000'
  4. Click OK
Did this article resolve the issue?