When setting a location type of Boundary>>One Country>>UK>>CensusAreas to a map and setting the location as the LSOA code a map is drawn with a set of boundaries but the boundaries do not reflect the area and is drawn in London rather than West Yorkshire.
I can't find any documentation online to establish what Census Areas are supported.
Has anyone come across any details?
ESRI - is this a feature that is work in progress?
Could you please share sample data of your table and post screenshot of your scenario so that we can test it further?
The source data is available at https://datahub.bradford.gov.uk/ebase/dp/LSOA.csv
The source data has been extracted from the ONS and can be seen via this link.
The following screen shot shows BI. I've created the ArcGIS map where location = LSOAcode.
Location Type>>Boundary>>One Country>>UK>>CensusArea
The codes are geocoded but incorrectly. The shape is wrong and the polygons are near Uxbridge, not Bradford, West Yorkshire.
I am not able to re-create the ArcGis map using your sample data, please check the screenshot in my scenario. Would you mind sharing me your PBIX file?
I couldn't get the ArcGIS map working and git the same problems you reported but if you follow the post from @mjfulke you could use the Shape visualisation instead.
I tried it with your data and I could get a map okay but frustatlingly I couldn't get the areas to colour correctly so it's all green in powerbi even after executing -svg-style fill="white".
I am sure there are people that would know what commands to execute in mapshaper to remove the fill and allow colour saturation to work correctly in power bi.
Ah no I did get it working both using the shape file export on kml export for bradford.
Thanks @gooranga we are using shape visualisations successfully but they are not very good at identifying where the polygon sits within the context of the district (area).
Even individuals who know the district struggle to work out where an area (in this case an LSOA) relates to the city/towns/villages etc.
Hopefully ESRI will resolve this issue as we are looking forward to being able to have polygons overlaid on a map (in addition to reference layers).
Check out a full recap of the month!
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.