Filled Map Visual

[marcush]

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

[v-yuezhe-msft]

@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]

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]

@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

[marcush]

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]

@marcush,

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

Regards,
Lydia

[marcush]

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. 

 

[v-yuezhe-msft]

@marcush,

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

Regards,
Lydia

[marcush]

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

County Short Name	County Long Name	State	State 2	County Name	County Name 2
Adams	Adams County	Wisconsin	WI	Adams County Wisconsin	Adams County WI
Ashland	Ashland County	Wisconsin	WI	Ashland County Wisconsin	Ashland County WI
Barron	Barron County	Wisconsin	WI	Barron County Wisconsin	Barron County WI
Bayfield	Bayfield County	Wisconsin	WI	Bayfield County Wisconsin	Bayfield County WI
Brown	Brown County	Wisconsin	WI	Brown County Wisconsin	Brown County WI
Buffalo	Buffalo County	Wisconsin	WI	Buffalo County Wisconsin	Buffalo County WI
Burnett	Burnett County	Wisconsin	WI	Burnett County Wisconsin	Burnett County WI
Calumet	Calumet County	Wisconsin	WI	Calumet County Wisconsin	Calumet County WI
Chippewa	Chippewa County	Wisconsin	WI	Chippewa County Wisconsin	Chippewa County WI
Clark	Clark County	Wisconsin	WI	Clark County Wisconsin	Clark County WI
Columbia	Columbia County	Wisconsin	WI	Columbia County Wisconsin	Columbia County WI
Crawford	Crawford County	Wisconsin	WI	Crawford County Wisconsin	Crawford County WI
Dane	Dane County	Wisconsin	WI	Dane County Wisconsin	Dane County WI
Dodge	Dodge County	Wisconsin	WI	Dodge County Wisconsin	Dodge County WI
Door	Door County	Wisconsin	WI	Door County Wisconsin	Door County WI
Douglas	Douglas County	Wisconsin	WI	Douglas County Wisconsin	Douglas County WI
Dunn	Dunn County	Wisconsin	WI	Dunn County Wisconsin	Dunn County WI
Eau Claire	Eau Claire County	Wisconsin	WI	Eau Claire County Wisconsin	Eau Claire County WI
Florence	Florence County	Wisconsin	WI	Florence County Wisconsin	Florence County WI
Fond Du Lac	Fond Du Lac County	Wisconsin	WI	Fond Du Lac County Wisconsin	Fond Du Lac County WI
Forest	Forest County	Wisconsin	WI	Forest County Wisconsin	Forest County WI
Grant	Grant County	Wisconsin	WI	Grant County Wisconsin	Grant County WI
Green	Green County	Wisconsin	WI	Green County Wisconsin	Green County WI
Green Lake	Green Lake County	Wisconsin	WI	Green Lake County Wisconsin	Green Lake County WI
Iowa	Iowa County	Wisconsin	WI	Iowa County Wisconsin	Iowa County WI
Iron	Iron County	Wisconsin	WI	Iron County Wisconsin	Iron County WI
Jackson	Jackson County	Wisconsin	WI	Jackson County Wisconsin	Jackson County WI
Jefferson	Jefferson County	Wisconsin	WI	Jefferson County Wisconsin	Jefferson County WI
Juneau	Juneau County	Wisconsin	WI	Juneau County Wisconsin	Juneau County WI
Kenosha	Kenosha County	Wisconsin	WI	Kenosha County Wisconsin	Kenosha County WI
Kewaunee	Kewaunee County	Wisconsin	WI	Kewaunee County Wisconsin	Kewaunee County WI
La Crosse	La Crosse County	Wisconsin	WI	La Crosse County Wisconsin	La Crosse County WI
Lafayette	Lafayette County	Wisconsin	WI	Lafayette County Wisconsin	Lafayette County WI
Langlade	Langlade County	Wisconsin	WI	Langlade County Wisconsin	Langlade County WI
Lincoln	Lincoln County	Wisconsin	WI	Lincoln County Wisconsin	Lincoln County WI
Manitowoc	Manitowoc County	Wisconsin	WI	Manitowoc County Wisconsin	Manitowoc County WI
Marathon	Marathon County	Wisconsin	WI	Marathon County Wisconsin	Marathon County WI
Marinette	Marinette County	Wisconsin	WI	Marinette County Wisconsin	Marinette County WI
Marquette	Marquette County	Wisconsin	WI	Marquette County Wisconsin	Marquette County WI
Menominee	Menominee County	Wisconsin	WI	Menominee County Wisconsin	Menominee County WI
Milwaukee	Milwaukee County	Wisconsin	WI	Milwaukee County Wisconsin	Milwaukee County WI
Monroe	Monroe County	Wisconsin	WI	Monroe County Wisconsin	Monroe County WI
Oconto	Oconto County	Wisconsin	WI	Oconto County Wisconsin	Oconto County WI
Oneida	Oneida County	Wisconsin	WI	Oneida County Wisconsin	Oneida County WI
Outagamie	Outagamie County	Wisconsin	WI	Outagamie County Wisconsin	Outagamie County WI
Ozaukee	Ozaukee County	Wisconsin	WI	Ozaukee County Wisconsin	Ozaukee County WI
Pepin	Pepin County	Wisconsin	WI	Pepin County Wisconsin	Pepin County WI
Pierce	Pierce County	Wisconsin	WI	Pierce County Wisconsin	Pierce County WI
Polk	Polk County	Wisconsin	WI	Polk County Wisconsin	Polk County WI
Portage	Portage County	Wisconsin	WI	Portage County Wisconsin	Portage County WI
Price	Price County	Wisconsin	WI	Price County Wisconsin	Price County WI
Racine	Racine County	Wisconsin	WI	Racine County Wisconsin	Racine County WI
Richland	Richland County	Wisconsin	WI	Richland County Wisconsin	Richland County WI
Rock	Rock County	Wisconsin	WI	Rock County Wisconsin	Rock County WI
Rusk	Rusk County	Wisconsin	WI	Rusk County Wisconsin	Rusk County WI
Sauk	Sauk County	Wisconsin	WI	Sauk County Wisconsin	Sauk County WI
Sawyer	Sawyer County	Wisconsin	WI	Sawyer County Wisconsin	Sawyer County WI
Shawano	Shawano County	Wisconsin	WI	Shawano County Wisconsin	Shawano County WI
Sheboygan	Sheboygan County	Wisconsin	WI	Sheboygan County Wisconsin	Sheboygan County WI
St. Croix	St. Croix County	Wisconsin	WI	St. Croix County Wisconsin	St. Croix County WI
Taylor	Taylor County	Wisconsin	WI	Taylor County Wisconsin	Taylor County WI
Trempealeau	Trempealeau County	Wisconsin	WI	Trempealeau County Wisconsin	Trempealeau County WI
Vernon	Vernon County	Wisconsin	WI	Vernon County Wisconsin	Vernon County WI
Vilas	Vilas County	Wisconsin	WI	Vilas County Wisconsin	Vilas County WI
Walworth	Walworth County	Wisconsin	WI	Walworth County Wisconsin	Walworth County WI
Washburn	Washburn County	Wisconsin	WI	Washburn County Wisconsin	Washburn County WI
Washington	Washington County	Wisconsin	WI	Washington County Wisconsin	Washington County WI
Waukesha	Waukesha County	Wisconsin	WI	Waukesha County Wisconsin	Waukesha County WI
Waupaca	Waupaca County	Wisconsin	WI	Waupaca County Wisconsin	Waupaca County WI
Waushara	Waushara County	Wisconsin	WI	Waushara County Wisconsin	Waushara County WI
Winnebago	Winnebago County	Wisconsin	WI	Winnebago County Wisconsin	Winnebago County WI
Wood	Wood County	Wisconsin	WI	Wood County Wisconsin	Wood County WI