Map chart for Canada not work for me

Hi guys, for any reason the map chart doesn't work well for me.

In orders table we have State (varchar 250) and Country (varchar 250), not work using this fields for CA *Canada, I make a Join for CountryList table and create a new columns Varchar(2) and Char(2)

I tried in production mode and dev test mode. I don't understand why US works well and Canada not working the data it's correct for example for abbreviations we don't have spaces and Region just show only "United States" in Region to select.



Capture3

{
 "browser-info": {
   "language": "en-CA",
   "platform": "Win32",
   "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:105.0) Gecko/20100101 Firefox/105.0",
   "vendor": ""
 },
 "system-info": {
   "file.encoding": "Cp1252",
   "java.runtime.name": "Java(TM) SE Runtime Environment",
   "java.runtime.version": "11.0.15.1+2-LTS-10",
   "java.vendor": "Oracle Corporation",
   "java.vendor.url": "https://openjdk.java.net/",
   "java.version": "11.0.15.1",
   "java.vm.name": "Java HotSpot(TM) 64-Bit Server VM",
   "java.vm.version": "11.0.15.1+2-LTS-10",
   "os.name": "Windows Server 2019",
   "os.version": "10.0",
   "user.language": "en",
   "user.timezone": "America/Los_Angeles"
 },
 "metabase-info": {
   "databases": [
     "h2",
     "sqlserver"
   ],
   "hosting-env": "unknown",
   "application-database": "mysql",
   "application-database-details": {
     "database": {
       "name": "MySQL",
       "version": "8.0.30"
     },
     "jdbc-driver": {
       "name": "MariaDB Connector/J",
       "version": "2.7.6"
     }
   },
   "run-mode": "prod",
   "version": {
     "date": "2022-09-02",
     "tag": "v0.44.3",
     "branch": "release-x.44.x",
     "hash": "7d50282"
   },
   "settings": {
     "report-timezone": null
   }
 }
}

Hi @lucas.dj
The "World" map is only countries in the world, and the "United States" map is only states in the US.
If you need regions in Canada, then you need to use a custom GeoJSON map:
https://www.metabase.com/docs/latest/configuring-metabase/custom-maps#custom-region-maps

Nice @flamber thank you so much!! now works fine!!