Map Visualization - Question on United State Counties

[jerryr125]

Hi -

I have question regarding the use of United States Counties on the Map Visualization.

In my data table / data load I have the following fields:

[LocationTable]:
LOAD
[SalesLocationID],
[City],
[State],
[Zip],
[City-State],
[Country Code],
[Latitude],
[Longitude],
[Region],
[Divison],
[County],
APPLYMAP( '__countryCodeIsoThree2Polygon', APPLYMAP( '__countryName2IsoThree', LOWER([Country Code])), '-') AS [LocationTable.Country Code_GeoInfo],
GeoMakePoint([Latitude], [Longitude]) AS [Longitude_Latitude]
FROM [lib://DataFiles/ABC123.xlsx]
(ooxml, embedded labels, table is LocationTable);

I have created a point layer using the longitude and latitude for the city - works perfect!

When I create an area layer for the County - some counties are not displaying in the correct state (just a few) as the county is related to the state and zip in the specific data row.

Any thoughts on how to make this would correctly ?

Thanks - Jerry

[jerryr125 · Accepted solution]

Got it !

I had to set two levels of administrative areas:

Works perfectly! Jerry