Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Filled Map Visual

I am trying to map the counties in 10 states and every county is mapping correctly in the Filled Map visual excep for Pepin County Wisconsin. The visual thinks this county is located where Dunn County Wisconsin is and has both of those counties sharing the same location. The area on the map for Pepin County is blank. This is the only county in the area that is not mapping correctly. Can you please fix this or let me know how I can fix it.

 

Thanks,

Marcus

Status: Needs Info
Comments
v-yuezhe-msft
Employee

@marcush,

Have you set Data category for your location field in Power BI Desktop?

To show the map as expected, I would recommend you prepare Lat/Long coodorindates for these locations in your data source, then drag the Lat/Long fields to the filled map.

Meanwhile, you can check the tips below about creating map in Power BI.
https://docs.microsoft.com/en-us/power-bi/power-bi-map-tips-and-tricks


Regards,
Lydia

marcush
Frequent Visitor

Lydia,

 

I have formatted my data as counties.

 

I don't think I want to use the Lat/Long coordinates because I want the data to fill the county not be a single point in the county. 

 

Marcus

v-yuezhe-msft
Employee

@marcush,

Which do you mean a single point?

When adding Lat/long fields in your map, it makes Bing map to correctly recognize your location, which will not impact the existing map visual.

Regards,
Lydia

Vicky_Song
Impactful Individual
Status changed to: Needs Info
 
marcush
Frequent Visitor

My data point I am trying to map is an entire county. How do I use Lat/Long fields to map an entire county?

 

Marcus

v-yuezhe-msft
Employee

@marcush,

Does the problem country show correctly in bing map? Could you please share sample data of your table here?

Regards,
Lydia

marcush
Frequent Visitor

Bing has 3 counties that it fails to locate. Attached is a copy of the data. Pepin County Wisconsin is the one that is failing to locate correctly in the filled map. Filled Map.JPGBing Map.JPG

 

 Sample Data.JPG

v-yuezhe-msft
Employee

@marcush,

Please share the data in a file that I can copy and paste.

Regards,
Lydia

marcush
Frequent Visitor

Here is the data for Wisconsin that I am trying to map.

 

County Short NameCounty Long NameStateState 2County NameCounty Name 2
AdamsAdams CountyWisconsinWIAdams County WisconsinAdams County WI
AshlandAshland CountyWisconsinWIAshland County WisconsinAshland County WI
BarronBarron CountyWisconsinWIBarron County WisconsinBarron County WI
BayfieldBayfield CountyWisconsinWIBayfield County WisconsinBayfield County WI
BrownBrown CountyWisconsinWIBrown County WisconsinBrown County WI
BuffaloBuffalo CountyWisconsinWIBuffalo County WisconsinBuffalo County WI
BurnettBurnett CountyWisconsinWIBurnett County WisconsinBurnett County WI
CalumetCalumet CountyWisconsinWICalumet County WisconsinCalumet County WI
ChippewaChippewa CountyWisconsinWIChippewa County WisconsinChippewa County WI
ClarkClark CountyWisconsinWIClark County WisconsinClark County WI
ColumbiaColumbia CountyWisconsinWIColumbia County WisconsinColumbia County WI
CrawfordCrawford CountyWisconsinWICrawford County WisconsinCrawford County WI
DaneDane CountyWisconsinWIDane County WisconsinDane County WI
DodgeDodge CountyWisconsinWIDodge County WisconsinDodge County WI
DoorDoor CountyWisconsinWIDoor County WisconsinDoor County WI
DouglasDouglas CountyWisconsinWIDouglas County WisconsinDouglas County WI
DunnDunn CountyWisconsinWIDunn County WisconsinDunn County WI
Eau ClaireEau Claire CountyWisconsinWIEau Claire County WisconsinEau Claire County WI
FlorenceFlorence CountyWisconsinWIFlorence County WisconsinFlorence County WI
Fond Du LacFond Du Lac CountyWisconsinWIFond Du Lac County WisconsinFond Du Lac County WI
ForestForest CountyWisconsinWIForest County WisconsinForest County WI
GrantGrant CountyWisconsinWIGrant County WisconsinGrant County WI
GreenGreen CountyWisconsinWIGreen County WisconsinGreen County WI
Green LakeGreen Lake CountyWisconsinWIGreen Lake County WisconsinGreen Lake County WI
IowaIowa CountyWisconsinWIIowa County WisconsinIowa County WI
IronIron CountyWisconsinWIIron County WisconsinIron County WI
JacksonJackson CountyWisconsinWIJackson County WisconsinJackson County WI
JeffersonJefferson CountyWisconsinWIJefferson County WisconsinJefferson County WI
JuneauJuneau CountyWisconsinWIJuneau County WisconsinJuneau County WI
KenoshaKenosha CountyWisconsinWIKenosha County WisconsinKenosha County WI
KewauneeKewaunee CountyWisconsinWIKewaunee County WisconsinKewaunee County WI
La CrosseLa Crosse CountyWisconsinWILa Crosse County WisconsinLa Crosse County WI
LafayetteLafayette CountyWisconsinWILafayette County WisconsinLafayette County WI
LangladeLanglade CountyWisconsinWILanglade County WisconsinLanglade County WI
LincolnLincoln CountyWisconsinWILincoln County WisconsinLincoln County WI
ManitowocManitowoc CountyWisconsinWIManitowoc County WisconsinManitowoc County WI
MarathonMarathon CountyWisconsinWIMarathon County WisconsinMarathon County WI
MarinetteMarinette CountyWisconsinWIMarinette County WisconsinMarinette County WI
MarquetteMarquette CountyWisconsinWIMarquette County WisconsinMarquette County WI
MenomineeMenominee CountyWisconsinWIMenominee County WisconsinMenominee County WI
MilwaukeeMilwaukee CountyWisconsinWIMilwaukee County WisconsinMilwaukee County WI
MonroeMonroe CountyWisconsinWIMonroe County WisconsinMonroe County WI
OcontoOconto CountyWisconsinWIOconto County WisconsinOconto County WI
OneidaOneida CountyWisconsinWIOneida County WisconsinOneida County WI
OutagamieOutagamie CountyWisconsinWIOutagamie County WisconsinOutagamie County WI
OzaukeeOzaukee CountyWisconsinWIOzaukee County WisconsinOzaukee County WI
PepinPepin CountyWisconsinWIPepin County WisconsinPepin County WI
PiercePierce CountyWisconsinWIPierce County WisconsinPierce County WI
PolkPolk CountyWisconsinWIPolk County WisconsinPolk County WI
PortagePortage CountyWisconsinWIPortage County WisconsinPortage County WI
PricePrice CountyWisconsinWIPrice County WisconsinPrice County WI
RacineRacine CountyWisconsinWIRacine County WisconsinRacine County WI
RichlandRichland CountyWisconsinWIRichland County WisconsinRichland County WI
RockRock CountyWisconsinWIRock County WisconsinRock County WI
RuskRusk CountyWisconsinWIRusk County WisconsinRusk County WI
SaukSauk CountyWisconsinWISauk County WisconsinSauk County WI
SawyerSawyer CountyWisconsinWISawyer County WisconsinSawyer County WI
ShawanoShawano CountyWisconsinWIShawano County WisconsinShawano County WI
SheboyganSheboygan CountyWisconsinWISheboygan County WisconsinSheboygan County WI
St. CroixSt. Croix CountyWisconsinWISt. Croix County WisconsinSt. Croix County WI
TaylorTaylor CountyWisconsinWITaylor County WisconsinTaylor County WI
TrempealeauTrempealeau CountyWisconsinWITrempealeau County WisconsinTrempealeau County WI
VernonVernon CountyWisconsinWIVernon County WisconsinVernon County WI
VilasVilas CountyWisconsinWIVilas County WisconsinVilas County WI
WalworthWalworth CountyWisconsinWIWalworth County WisconsinWalworth County WI
WashburnWashburn CountyWisconsinWIWashburn County WisconsinWashburn County WI
WashingtonWashington CountyWisconsinWIWashington County WisconsinWashington County WI
WaukeshaWaukesha CountyWisconsinWIWaukesha County WisconsinWaukesha County WI
WaupacaWaupaca CountyWisconsinWIWaupaca County WisconsinWaupaca County WI
WausharaWaushara CountyWisconsinWIWaushara County WisconsinWaushara County WI
WinnebagoWinnebago CountyWisconsinWIWinnebago County WisconsinWinnebago County WI
WoodWood CountyWisconsinWIWood County WisconsinWood County WI