KNOWLEDGE BASE

Some Of The Japanese Counties Are Not Recognized And Displayed In The Map On Tableau Desktop


Published: 07 Dec 2020
Last Modified Date: 08 Dec 2020

Question

The cities/counties places in Japan below are not recognized as counties and not displayed in the map.
 

北海道伊達市
栃木県那珂川町
福島県伊達市
広島県府中市
東京都中央区
東京都北区
東京都港区
東京都府中市

Environment

  • Tableau Desktop

Answer

Workaround

Create 2 dimensions in the original data source, one for State(都道府県), and one for Counties(郡).
Add both State(都道府県) and Counties(郡) to the view.
Please see attached workbook geographical roles.twbx for more details.

Additional Information

This can happen with other regions/maps when there are duplicate names where you need more contexts to distinguish/clear the ambiguities e.g.
 
CountryStateCity
CanadaNova ScotiaSydney
AustraliaNew South WalesSydney
Did this article resolve the issue?