Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Let me give you an example just to give you context. You want to plot the following:
- All physical locations for McDonald's restaurants with a dot (no latitude/longitude coordinates...only physical addresses)
- All physical locations for supply vendors for McDonald's restaurants with a pin (ex: color coded by = meat / drink / bread / misc)
Ultimately, the scope of this map should be quite complex. The vast number of global locations, color coding of the various vendors, etc. I am struggling with something simular. I have an imported query which has addresses and would like to plot multiple locations in conjunction with another data point.
Problem:
1. I cannot get the locations to be accurate. I have physical addresses and have the data categories correctly marked as either address/city/state/zip/country but it will not accurately plot the location
- EX: Country location clearly marked as Brazil but no location on the map
2. Unable to plot more than 1,500 addresses AND more than 1 data point
- EX: I can only plot a physical McDonalds store location. Not able to plot the supply vendors for McDonalds
3. The bubbles on the map are just too big...why can't I get it to look like the ArcGIS bubbles?
Anyone have any examples or suggestions on how you would approach creating an interactive/dynamic map which will be able to have accurate multiple data points which will be visually appealing?
So much gratitude for this community of datanauts!
Hi @Anonymous
Here are some posts for you to check if they could help you.
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks
https://community.powerbi.com/t5/Desktop/Map-point-limits-for-postcodes-current/td-p/219528
https://dataveld.com/2017/06/03/10-ways-to-create-maps-in-microsoft-power-bi/
Regards,
Cherie
User | Count |
---|---|
95 | |
86 | |
78 | |
72 | |
66 |
User | Count |
---|---|
113 | |
105 | |
85 | |
65 | |
64 |