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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Whibley92
Frequent 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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors