Esri ArcMap visual missing local authorities UK.

[AlexW_82]

Hi,

Having completed several maps for a published dashboard using the Azure Maps visual and then realising this was a waste of time as they do not work when published to web... I reverted back to trying to use the ArcGIS Map visual, but it won't work properly.

I want UK Local Authority Districts (LAD) as polygons, which i can then fill with a colour gradient.

My geography dataset contains LAD name, code, longitude and latitude. I can set the LAD name or codes to "Address" in the data category, or use the long/lat and achieve all the correct locations appearing as points, but when I change the location setting to boundaries, some disappear. I believe the ones that disappear are the LADs that changed as of April 2023. I can pinpoint the issue further, the LAD in the Yorkshire region which changed is North Yorkshire. If I change the drop down box under boundaries from Districts to Counties, North Yorkshire then appears, but this loses lots of LADs.

Screenshot showing points. North Yorkshire circled.

Screenshot showing when boundaries are selected and District in location type. North Yorkshire is blank, but East Riding (selected) appears to be labelled as North Yorkshire as well as East Riding (if I filter out North Yorkshire, the tool tip presents East Riding).

Screenshot of location type as Counties. North Yorkshire circled but lots of local authorities missing.

I have also tried using a slightly different dataset called "Counties and Unitary authorities" and the same problem persists.

For reference, i get my geographies from here, https://geoportal.statistics.gov.uk/datasets/ons::local-authority-districts-may-2023-boundaries-uk-b...

I have wasted 3 days so far trying to make this work/find a working alternative to the Azure Map visual. PBIs suggestion everytime I open it, that I change all my maps to the Azure Map which isn't fit for purpose just adds to the already high levels of frustration.

Please help me, I'm surely not the only person in the UK trying to map things by 2023 Local authority districts.

Thanks

[AlexW_82]

Thank you for your prompt response. I will explore the Mapbox option.

I have got shapefiles created in ArcMap Desktop, but when I add them to ArcGis Map visual in PBI I can't seem to change the Symbology, even though I join the layers. So iI essentailly have the base map, with the shapefile on top and points for the location, which can be made bigger or different colours according to size or legend etc. but not the gradient filled polygons I want.

[AmiraBedh · Accepted solution]

I think in your use case mapping data is often tricky due to evolving political and administrative boundaries. You could consider leveraging GIS software such as ArcGIS Desktop or QGIS to navigate this. These platforms allow for manual boundary adjustments and merging of various shapefiles to create a desired geography. Once you've defined the boundaries, you can export this data as a shapefile and import it directly into the ArcGIS Map visual, ensuring consistent data types for your LAD codes and names. Another route is to explore alternative Power BI custom visuals or plugins that handle geographic data; a prominent option in this domain is Mapbox. Also the inconsistencies might be rooted in Esri's own data or a possible bug, so I recommend you to reach out directly to Esri to flag this issue, ensuring in parallel that your Power BI Desktop and ArcGIS Map visual tools are up-to-date.