Forum Discussion
FJME
Helper I
Helper IMAP CHART
MY MAP CHART DON'T PRESENT THE BUBBLES..THEY ARE ONLY VISIBLE AFTER LONGITUDE ANS LATITUDE DATA ENTRY. I changed data sets, pbi desktop versions but the problem remains. best regards Francisco...
Hi @FJME ,
We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
B Manikanteswara Reddy
Hi FJME ,
you can try these steps,
--Check that Latitude and Longitude Are Numeric
Also confirm that both columns have data type = Decimal Number in Power BI.
--Make sure the Latitude and Longitude values use periods (.) as decimal separators, not commas (,)
Correct : 48.85661
Incorrect: 48,85661
--Set Correct Data Categories
Click on each of the following columns and assign the correct Data Category from the Column Tools tab(refer the image that attached)
Column Data Category
------- --------------
Country Country/Region
Latitude Latitude
Longitude Longitude
if you keep country in the location field well , you may get the error as attached screenshot, then you can
Fix Aggregation Error in Map Visual as below:
Either:
Remove the Country from the Location field, and use only Latitude, Longitude, and Value.
Or:
Keep Country in Location and set the Latitude and Longitude fields to aggregate as "Average".
You can do this by:
-------------------
Clicking the dropdown next to Latitude/Longitude in the visual’s fields pane
Select “Average” as the aggregation
I have attached the .pbix file for your reference.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
B Manikanteswara Reddy
