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.
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!
Solved! Go to 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:
Tips and Tricks for Power BI Map visualizations
Best Regards,
QiuyunYu
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:
Tips and Tricks for Power BI Map visualizations
Best Regards,
QiuyunYu
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.
User | Count |
---|---|
88 | |
74 | |
69 | |
65 | |
58 |
User | Count |
---|---|
104 | |
94 | |
76 | |
62 | |
59 |