Filled map issue with counties in Connecticut

[npnigro]

Some of the polygons for Connecticut counties stopped working recently. All other counties in the U.S. work with this visual. If I add in the Lat/Long, then the map changes and gets a little better, but is still wrong. This is an issue with the Azure map visual and the native fill map visual. See image below without Lat/Long: 

Image with Lat/Long:

[v-yetao1-msft]

Hi @npnigro 

What should a Filled map look like under normal circumstances?

Best Regards,
Community Support Team _ Ailsa Tao

[npnigro]

The entire state should be filled in. 

[DrMKVHA]

I've noticed the same issue with Connecticut. My maps used to fill in the entire state and new issues with individual counties are resulting in bare and overlapping regions (resulting in darker patches), as shown in Figure 1. I've tried to find a workaround and not yet found anything that works.

The issue of overlapping and missing shapes appears to be with four counties:

• Fairfield County, CT - Shape appears to generally wrong and particularly missing a chunk from the ESE, resulting in a gap to the east between it and New Haven County, CT
• Hartford County, CT - Shape is equivalent to Tolland County, CT
• New Haven County, CT - Shape appears to be generally wrong and particularly missing a chunk from the WNW, resulting in a gap to the west between it and Fairfield County, CT
• Tolland County, CT - Shape is equivalent to Hartford County, CT

As a more general issue, all of the county shapes for Connecticut appear to be wrong, which can be seen by comparing the Power BI county map (see Figure 2) with a set of ground truth shapes (Figure 3), found through a search of the CT state website [CT Vicinity County Polygon | CT Vicinity County Polygon | CT DEEP GIS Open Data Website (arcgis.com)].

Figure 1: Map of all CT counties in Power BI; note the darker patch is two overlapping county shapes

Figure 2: Map of all CT counties in Power BI, broken out in different colors

Figure 3: GIS county map from CT.gov state website

[DrMKVHA]

P.S. Here's what the continguous US currently looks like in Power BI with all counties filled in. It's a fairly small blemish when looking at the entire country, but becomes pretty unmistakeable in analyses that focus in on the northern east coast.

[DrMKVHA]

@v-yetao1-msft 

Any updates on whether a solution is in the works for this issue?

[BI_Tiffin]

I have the same issue with my Power BI - Filled Map

@v-yetao1-msft 

Any updates regarding this issue?

[BI_Tiffin]

@v-yetao1-msftany plan to investigate this issue, seems like we are encountering a particular mistake in the filled map for Connecticut.

[Thorts]

The same issue is also present in Excel filled maps too.  @v-yetao1-msft do you know if there are any updates to fix this?  Thanks -

[zachleber]

There is no bug in the software. Connecticut (CT) made the dramatic change of officially replacing their 8 counties with 9 regions in 2023. The old counties will no longer work in new versions of mapping programs like PowerBI or Tableau. There is no workaround other than to re-map your raw data to the CT regions instead of the counties. We have to update our ZIP code database for example. This change by CT is hugely disruptive.

https://www.federalregister.gov/documents/2020/12/14/2020-27459/change-to-county-equivalents-in-the-...

[Anant89]

I agree with you. Connecticut has recently updated their county level boundaries to "planning regions". However, there is still the issue of adequately mapping these "planning regions" in Excel filled maps. Please take a look at the snapshot, the new Connecticut planning regions are not recognised by Microsoft excel tool as "valid" geographies. As a result, nothing gets mapped for the state of Connecticut now.

Please note: the first region "Capital Planning Region, Connecticut" has been incorrectly mapped to "Washington DC" by the tool which is also not right. (I think its because the region name has the word "Capital" in it".)

Kindly review the issue: @v-yetao1-msft (Below are the snapshots for your reference as well as source links)

Snapshot from my worksheet. First colum is the original name of planning county in CT. Second column is the same data converted in Geography format.

Map of CT "Planning Regions" published by American Community Survey Website (Link Below).

Source: 

https://data.census.gov/map/040XX00US09$0500000/ACSDT5Y2022/B25040/B25040_002E?q=house%20heating%20f...

The above map has been created by American Community Survey website using the US Census Bureau (2022 TIGER/Line® Shapefiles: Counties (and equivalent)). Link for the same is below.

https://www.census.gov/cgi-bin/geo/shapefiles/index.php?year=2022&layergroup=Counties+%28and+equival...