Map bubble size aggregating issue

[PDM83]

Hi all,

I cannot share the data, as access to it is by paid membership, however, I will do my best to describe the issue.

I have wind farm installations information and I would like to plot it on a map. I have used the latitude and longitude to locate the point, and I used the owner as a legend so that each bubble from the same owner will have the same colour. I have inserted the age of the installation in the tooltips.

The result is below.

  

There are so many different owners and combinations of them per site, that it is quite confusing at this scale, but it just shows that there is no major dominant force...in terms of a number of windfarms, which might not be the case when one would run some statistics using the installed power...but that is not my concern.

I want to use the number of wind turbines in each wind farm, as the size of the bubble size, so to spot the largest installations from the smallest. 

When I add it as the bubble size parameter, something strange happens.

 

It is as if most projects disappear...it is not that larger installations are shadowing smaller ones, if you notice, any dot in Greece or Portugal has disappeared.

My feeling is that, instead of using the Number of Generators associated with each dot to make the bubble smaller or larger, for some reason, data gets aggregated, and obviously, many smaller dots, become 1 dot, where the location used is probably the first, or last...or whatever the software decides

In fact, I can choose "Don't summarize" for the latitude and longitude, but I cannot do that for either the Age or the Number of generators. There is always an aggregating function, such as Sum, Max, Min, etc...

I have tried the ArcGIS map, which does a better job in terms of keeping the dots, however, it does not show more than a certain number of different colours for owners, like up to 10 different ones are listed with different colours. anything else is classified as a great "other".

I have seen the posts about the limit in the number of entries. I would expect that to be a warning in the visual, when that happens.

Anybody experienced the above, and has any suggestions?

Thanks in advance for your help and suggestions.

Regards,

Pietro

[HotChilli · Accepted solution]

The limits are here : https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-data-points#map 

so I suspect it's being limited to 15 bubbles. You can test that at your side.  I suppose there is a reason for it but it does seem a low limit.

[PDM83]

You are correct.

However, I am not adding data by adding the turbine numbers in each location as a bubble size parameter. Why without it no warnings appear and it does it right, and adding it creates a problem?

[HotChilli]

I can see the 'i' in the chart at the top so that will probably say that the number of plot points has been limited.