Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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)
Solved! Go to 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
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".
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