Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Power BI Map Visual Bubbles Disappear After Adding Legend or Bubble Size Field

I am using Latitude/Longitude coordinates to plot location points on a map. The bubbles appear fine when just the Lat & Long fields are input into the Power BI normal Map visual. However, when I try to add a field - which is a simple count measure - into the Bubble Size field, or add a unique type field into Legend to show different colours, every single bubble immediately disappears, with no error message from Power BI as well. Any idea on why this happens? I only have 500+ data points. Same thing happens with ARCGis maps, I tried Filled Map but it doesn't really serve my purpose, and for Azure Map, I don't have access to it yet. How do I fix this with the normal Map Visual? Thank you.Bubbles appear fine with just Lat/Long fieldsBubbles disappear when Bubble size field is filledBubbles disappear when Legend field is filled
 
Update: Showing error message after clicking on the 'i' button.

Now if the Lat/Long values are invalid, how did Power BI display the original visual in the first place? 

 

Need Help
Tutorial Requests

5 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion
    2 years ago

    Please provide more details.

    We need to see the model and a data sample and what the measure (Number of Claims) is. 

    Please click on the 'i' in the map visual (top right) to see what message powerbi is giving you.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi HotChilli, 

      Unfortunately I am unable to reveal my dataset as it is confidential, but I can give a simple analogy. 
      Imagine that every bubble represents a water pipe that leaks. Some of them leak once, while some of them get fixed and then leaked again. My data contains information of the pipe ID (e.g. Pipe 1, Pipe 2, Pipe 348), and also the different manufacturer for every pipe (Model (groups)). So every time a pipe leaks, a record is added to the dataset, with the Pipe ID, the manufacturer name, and the location of the leak. I derived (Number of Claims) with COUNT('Table'[Pipe ID]). 

       

      As for the 'i', I have indeed found the 'i' button that you were referring to. Now if the Lat/Long values were invalid, how did Power BI display the original visual in the first place? 

       

      Thank you

  • cbndnl's avatar
    cbndnl
    New Member
    2 years ago

    Hi, Did you find the solution? 

    It happens to me the same 

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    2 years ago

    I have the same problem. Or you add the legend or bubble size metric. But he doesn't leave both... 😞

  • emorrell's avatar
    emorrell
    Frequent Visitor
    1 year ago

    I have this same issue. All my data is plotted correctly until I add the field for bubble size, and then some of my bubbles dissappear. I have looked at all the data in a table, and the issue is not that the value for bubble size is 0.