ArcGis PBI reference layer for Coordinates

Question

Hello All!, I have PBI dataset with zip code, latitude, longitude, branch name and stock count. I would like to have zip code demarcation and also latitude and longitude coordinates as pins/points on map. I am able to achieve Zipcode demarcation with color coding as per branch name, but unable to join my latitude and longitude coordinates with any existing reference layers so that i can have pins too on map. Please help if possible. Thanks in advance!!

ArcGisZipVsCorordinates.PNG

AndreasHall · Answer

If you want to use the join layer functionality and join your data to a reference layer from ArcGIS Online/Enterprise you should base the join on some kind of unique ID, not on latitude and longitude.

AndreasHall · Answer

Hi, the ArcGIS for Power BI visual is limited to showing one type of location based on data in Power BI (zip code demarcation or points in your case). What I think you could try is to add two ArcGIS for Power BI visuals, one showing zip code demarcation and one showing points based on latitude and longitude. Another way to do it is to show your data based on latitude and longitude and add zip codes as reference layers from ArcGIS Online. However, reference layers have limited functionality so it depends on your use case if it will work for you.