I can see you loading the data locally from KML file.
I'd suggest Delete all other states except Wisconsin, Illinois, and Indiana.
State Latitude Longitude
Wisconsin xxxxxxx xxxxxxx
Illinois xxxxxx xxxxxx
Indiana xxxxxx xxxxxx
Your script will look
[Latitude] as LATITUDE,
[Longitude] as LONGITUDE,
GeoMakePoint(Latitude,Longitude) as GeoKey
FROM [lib://AttachedFiles/US States.kml]
(kml, Table is [US-States.shp/Features])
Do not forget to make a GeoKey for this, so that you can use this as a Layer. Cus you using a bubble map and it is not a polygon map.
For Polygon map it is not required I guess.
And then you can load full KML file with all states and all Lat & Long but do not add GeoMakePoint in this script.
So you'll have 2 data sets loaded
1. Only with States which you want to load inside map
2. Full load of data set
You'll get a Synthetic key but change the names of Latitude and Longitude in each load. State name will be same and it will be the primary key.