cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Plotting Canadian Cities an a Map Offline

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! 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Helper II
Helper II

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.

 

 

Highlighted
Community Support
Community Support

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors