Ron, Tableau recognizes only 3-digit Canadian postal codes, so if your's are 7-digits (including the space) you'll need to trim them down. Also, since you're mixing countries, you'll need a 'Country' field so Tableau doesn't get lost. Here's the calc:
IIF(LEN([Zip])=7, LEFT([Zip],3), [Zip])
Put it in a calculated field, and then give it a geographic role of "ZIP Code/Postcode". Last you'll need to 'Edit Location' and switch from the default 'Fixed' to the 'From field' using your Country field:
See attached. Good luck.
US-Can.twbx.zip 38.7 KB