Forum Discussion
IconMap - Geojson and multiple Lat/Long
I'm using the brilliant IconMap (Icon Map (icon-map.com)) but am struggling to get the setup correct for displaying two different lat/longs on top of a geojson choropleth map.
In simple terms, I have two locations (Site A and Site B), and a count of customers from different postcode districts. Combining this with a geojson file creates a nice choropleth map:
Now I want to display the site location's with a basic shape. When bringing in the lat/long, powerbi forces an average, so I get the midpoint between the two sites:
As opposed to the location of the two sites - when I remove the category for the postcode district and add just an id field, I get the two sites showing correctly, but lose the postcode districts:
Is there a way to keep both the choropleth aspects of the map with the individual lat/long plotted on top as shapes?
Example of my table setup below:
| ID | Site_Code | Postcode_District | Customer_Count | Lat | Long |
| 1 | Site A | TN23 | 918 | ||
| 2 | Site A | TN24 | 781 | ||
| 3 | Site A | CT19 | 487 | ||
| 4 | Site A | ME13 | 392 | ||
| 5 | Site A | CT17 | 371 | ||
| 6 | Site B | CT9 | 1159 | ||
| 7 | Site B | CT6 | 610 | ||
| 8 | Site B | CT11 | 606 | ||
| 9 | Site B | CT14 | 562 | ||
| 10 | Site B | CT10 | 444 | ||
| 11 | Site B | 5 | 1.38 | 51.37 | |
| 12 | Site A | 5 | 0.91 | 51.14 |
1 Reply
Hi, paulbullard
You can try separating the data sources into two datasets, one with the zip code area and the number of customers. For the other, it contains data on the latitude and longitude of Site A and Site B.
If you can, you can provide your Geojson file and go into more detail about your desired results, while paying attention to your privacy and not divulging your personal information.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
