Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Whibley92
Helper II
Helper II

Layering 2 sets of postcodes ArcGIS POWERBI

 

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?

 

 

3 REPLIES 3
v-yalanwu-msft
Community Support
Community Support

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.

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

hi @v-yalanwu-msft 

 

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

Store IDPostocde
12345CH5 1UA
23456HU7 3DA
54311WA3 3SP
76536OL6 7PF
64234LE10 1SS
64243WN7 5RZ
HotelPostcode
AB HotelLS16 7YR
Black  HotelCF1 7JL
Ham HotelNE11 9XS
Youngs HotelG77 6EY
Old HotelPL25 4PR
Upper HotelDA11 0DQ

 

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

 

Whibley92_0-1668682294132.png

 

 

 

 

 

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors