Plotting Canadian Cities an a Map Offline

[afkl99]

Hi, 

I'm using Power BI Desktop offline (but do have access to internet on a seperate device). I would like make a bubble plot of canadain cities on a map. I already have a table with the city and province name along with its latitude and longitude. 

I was able to sucessfully use a shape map and json file to do a heatmap of provinces, but now I'm stuck on the cities.

Thank you for your help! 

[v-qiuyu-msft · Accepted solution]

Hi @afkl99,

Firstly, I would like to deliver the use scenario of the shape map in Power BI. Shape Map cannot show precise geographical locations of data points on a map; instead, its main purpose is to show relative comparisons of regions on a map by coloring them differently. See: Shape Maps in Power BI Desktop (Preview). Both Location and Legend properties can only have one column. If you already put the province column in Location, you can try to put City column in legend to category the data.

To bubble plot Canada cities, I would suggest you use Map visual. For details, you can refer to below links:

How to Use Map Visualizations

Tips and Tricks for Power BI Map visualizations

Best Regards,
QiuyunYu

[Rich_P]

I just happened to watching a video by Chris Webb this week. I think it may be right up your alley. Check it out here. Around the 27 minute mark I think.