Last Modified Date: 31 Jul 2018
Option 1Since Tableau Desktop 2018.2, you can now use geocode common geographies and detailed 7-digit postal codes for Japan. Upgrade to Tableau Desktop 2018.2 or a later version to take advantage of this new feature. For more information, see Upgrading Tableau Desktop in Tableau Help.
Option 2Tableau Desktop recognizes only the first three digits of Japanese postal codes. The following instructions demonstrate how a calculated field can be used to display only the first three digits of a seven-digit postal code.
- In Tableau Desktop, connect to a data source that has seven-digit Japanese postal codes.
- In the Data pane, right-click the postal code dimension and select Change Data Type > String.
- Click Analysis > Create Calculated Field and create a calculated field to split the first 3 digits from the remainder of the postal code. For example:
- Right-click the new calculated field and select Geographic Role > ZIP Code/Postcode.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials