Forum Discussion

CJenner's avatar
CJenner
Advocate I
11 years ago

more location data required?

Ever since the Launch, I had a map that worked using zipcode now, the same chart gives me the following error:   To create a filled map, the Location data should include Bing Map-supported geograph...
skiwii's avatar
skiwii
Advocate I
10 years ago

I tried naming my fields [Postal Code] and the American name of [Zip Code] but no cigar.  I even tried a concatenation of City, Postal Code and Country in one field but again no luck.  The only way I could get this to work was to concatenate the latitude and longitude together in a string with a comma separating the two.

Note that I my data is in Excel tables and not a cube.  In SSAS at least you can define an attribute with a Geography type, but I doubt this will work.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

skiwii - Coming in late to this conversation, but it seems like the trick that is missing is Data Categorization. I created a Enter Data query with some zip codes, doesn't matter what the column is called, mine was called Zips.

 

In the model, change the data categorization to "Postal Code".  If you had Country, you would categorize it as "Country", etc.

 

Place the categorized fields in the Location area. See below: