cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Whibley92
Regular Visitor

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors