help with maps and sales

[unclejemima]

I've got a canadian and usa customer list with a few tables.

1 table for invoice pricing

1 table for customers and their postal code

1 table for Location data, Postal/Zip codes for all USA and Canadian postal/zip codes and what the corisponding city and state is.

I made a relation ship between

-InvoiceTable[CustomerName] and CustomerTable[CustomerName]

-CustomerTable[PostalCode] and LocationData[Postal/Zip]

I tried putting the info on the map with Location being 'CustomerTable'[PostalCode] and 'InvoiceTable'[SalesAmount] but nothing popluates on the map.

I have all the location fields types in the proper format format under Modeling>Data Category. 

Any idea's?

[v-ljerr-msft]

Hi @unclejemima,

According to your description above, it should work if the postcodes are in a format that can be identified by Bing Map.

Could you post some sample data here, so that we can help further investigate on it? 

Regards

[unclejemima · Accepted solution]

Ah!  Got it sorted.  My postal code database had no spaces (T2E2T3) when my customer DB had a space (T2E 2T3).

Problem solved.

I also ended up putting the full city, province(state) and country(long description) as a place, and that solved some of the inaccurate postings.

Using for example Ottawa, On, CA did not work very well but Ottowa, Ontatio, Canada and it works fine with Bing.

[GilbertQ]

Hi @unclejemima

Have you tried to use the ShapeMap Visual and ensure that the map is set to USA and see if that works?

Also what is the data type set for your Postal Codes?