Forum Discussion

FJME's avatar
FJME
Helper I
1 year ago
Solved

MAP 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

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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

6 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    1 year ago

    Hi FJME  - In Power Query, check that your latitude and longitude fields are data type: Decimal Number (not Text).

    In Model View, ensure they are categorized as Latitude and Longitude:

    Select the column

    Go to Column Tools > Data Category

    Set Latitude and Longitude accordingly.

    Ensure it is categorized as City, State, or Country under Data Category.

    Power BI may struggle with ambiguous names, so include full addresses or country names if necessary.

    similar issue:

    https://community.powerbi.com/t5/Service/I-dont-see-bubble-in-the-map/m-p/320463

    https://community.powerbi.com/t5/Issues/Potential-bug-with-native-quot-map-quot-visual-and-bubbles/bc-p/2001834

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi FJME,

     

    we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
    If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

    Regards,
    B Manikanteswara Reddy

    • FJME's avatar
      FJME
      Helper I
      1 year ago

      Hi v-bmanikante!

      My apologies for delay. Your answer didn't acheive my doubt, maybe i didn't explain the problem in the correct form..Let me detail a bit more:

      • Problem description: bubles not visible in Power BI Map Visual
      • Map Parameters:
        • Location: [Country] table field with countries (filled in all lines)
        • Bubles Size: [Soma de Value] numeric field (filled in all lines)
      • Data: in attach (Excel workesheet with 10 records and  columns) includes:
        • Country (10 european countries)
        • Latitude (for each country)
        • Longitude (for each country)
        • Value (a different number value (between 100 and 1000 for each country)

      As we can see in below image, when i put Country in Location and Value in Bubbles size i have no results. Otherwise, if i add Latitude and Longitude i can see the bubbles. I also include in attach the  “.pbix” file.

      I inform that i tested with different data, i uninstalled and reinstalled the  PowerBI (both versions - 32bit and 64bit) but the problem remains.

      Best regards

      PS: If needed i'll send the .pbi file (i don't know how in attach...)

      CountryLatitudeLongitudeValue
      Portugal38,73695-9,14269100
      Spain40,41678-3,70379200
      France48,856612,352222300
      Germany52,5200113,40495400
      Italy41,9027812,49637500
      United Kingdom51,50735-0,12776600
      Netherlands52,367574,904138700
      Belgium50,850354,351721800
      Switzerland46,204396,143158900
      Austria48,2081716,373821000
  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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!

    Regards,
    B Manikanteswara Reddy
  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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