Layering 2 sets of postcodes ArcGIS POWERBI

[Whibley92]

I am trying to layer 2 sets of postcode (one set are stores, one set are schools) to show how many schools in the same area as stores.

I saw this  https://community.powerbi.com/t5/Desktop/ArcGIS-maps-with-multiple-data-sets/m-p/1170926#M528089

I have tried following it but can I not just put a custom label in the spreadsheet itself rather than trying to append in PowerBI?

[v-yalanwu-msft]

Hi, @Whibley92 ;

Based on my understanding, it should be possible, can you create a simple test file, along with the results you want to output and the logic behind it?

It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

Solved: How to upload PBI in Community - Microsoft Power BI Community

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Whibley92]

Hello @v-yalanwu-msft did you have any advice on how to plot how many hotels near specific areas?

[Whibley92]

hi @v-yalanwu-msft 

this is the data but there are 1300 hotels and 600 stores. 

Store ID	Postocde
12345	CH5 1UA
23456	HU7 3DA
54311	WA3 3SP
76536	OL6 7PF
64234	LE10 1SS
64243	WN7 5RZ

Hotel	Postcode
AB Hotel	LS16 7YR
Black  Hotel	CF1 7JL
Ham Hotel	NE11 9XS
Youngs Hotel	G77 6EY
Old Hotel	PL25 4PR
Upper Hotel	DA11 0DQ

I've managed to plot this, but we want to show how many hotels near each store