Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
BettyG
Frequent Visitor

Controlling size of bubble on map visualization

I have a map visualization that shows the Port of Entry and I have the Value of the products chosen to control the size of the bubble.  This is working fine on the Desktop Report.  However, when I publish to Power BI and review the report, all of the Bubbles are the same size.  What am I doing wrong?  The 1st snapshot below is from Desktop, the 2nd is after publishing to Power BI.  (I hope you can see the screenshots)

 

MapOnDesktop.png

 

 

 

 

 

 

MapOnPowerBi.png

 

 

1 ACCEPTED SOLUTION

Hi @BettyG

 

Here are two links after a quick Google. You can just do a search until you find what will fit your requirements

 

https://opendata.stackexchange.com/questions/6800/list-of-united-states-cities

 

https://www.uscitieslist.org/





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

5 REPLIES 5
GilbertQ
Super User
Super User

Hi there

Have you tried in the Power BI Service to remove the size and then put it back in and see if that works?

Or also change the visual to something else and change it back in the Power BI Service?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Yes, I've tried both suggestions several times.  After looking closer, I see that the part of the problem is that the Desktop App recognizes most of the names of the Ports of Entry, but the Power BI Service is not recognizing the same ones.  I have them categorized as "Place".

Hi there if possible I would then rather put in the actual addresses or locations which will map correctly.

The underlying technology uses Bing Maps API, so if you want to test if it works, go go Bing Maps and type it into the Search Bar and see if it finds your location.

I generally suggest to people to use either an address or Lat and Long to ensure that it will work and put the data in the correct location on the map.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Any idea why the Desktop version recognizes some names that the Power BI Service does not?

 

Unfortunately, the name comes in as part of a large file that is downloaded.  I guess I will have to add a conditional column to replace the names that are not being recognized on Power BI Service.  As long as I'm doing that, do you know of a table that I could download with the US City Name and the corresponding Lat/Long?

 

Thanks for your help.

Hi @BettyG

 

Here are two links after a quick Google. You can just do a search until you find what will fit your requirements

 

https://opendata.stackexchange.com/questions/6800/list-of-united-states-cities

 

https://www.uscitieslist.org/





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors