England maps by region and local authority

[ChrisG]

Hi

I'm a new user of Power BI and I'm trying to create filled maps for England, firstly by region and then by local authority. Starting with region, my data has the region name (North East, North West, etc.) and ecode (E12000001, E12000002, etc.).

So far I've got absolutely nowhere and I can't seem to find out what I need to do by searching online. Can I use my region name or ecode fields or do I need to use something else?

Any advice would be very much appreciated. Please remember I'm a complete beginner!

Thanks 

[v-shex-msft]

Hi @ChrisG,

Since you are a beginner, I'd like to suggest you take a look at below tutorial first:

Filled maps (choropleths) in Power BI (Tutorial)

Regards,

Xiaoxin Sheng

[ChrisG]

Hi Xiaoxin

Thanks for the response. I had already found that page. I feel like I can't go through those instructions as I can't get anywhere with my data. My only problem at the moment is knowing how to use my England data and whether or not I'll be able to produce filled maps by region and local authority.

Do you have any thoughts on what I can do with my data?

Thanks

Chris

[v-shex-msft]

Hi @ChrisG,

Based on test, the ecode seems not works on filled map, can you share us some sample data to test?

Regards,

Xiaoxin Sheng

[RobFair]

Hi chris G

What is it you want to do?

If you are looking at generating a heatmap you can do uit with a shapemap in power BI.  all you need to do is generate a JSON base map, feed it into shape map and then put in the data you want.

I also have the CCG's mapped in JSON

Whetre i work  (NHS) i cant set up links to pages to share. but if you want to e-mail me my home e-mail is clayman1302@gmail.com 

[ChrisG]

Hi,

I'm trying to use the tables published here https://www.gov.uk/government/statistics/private-rental-market-summary-statistics-october-2015-to-se...

Specifically I've been looking at Table 1.7.

I installed the ArcGIS add in and that seems to be working ok. Is that the best way to go?

What I'm now hoping to do using the ArcGIS add in is to have both region and local authority data on the same map. So if someone is looking at the whole of England it will show the regional data, then if they click on a region it will show the local authorites within that region. Is this possible?

Thanks

[v-shex-msft]

Hi @ChrisG,

>>So if someone is looking at the whole of England it will show the regional data, then if they click on a region it will show the local authorites within that region. Is this possible?

Based on research, current arcgis map seems not support the data label feature. For your requirement, you can submit it to ideas.

Regards,

Xiaoxin Sheng