Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Regular Visitor

Map bubble size aggregating issue

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.

PDM83_0-1691161561034.png  PDM83_1-1691161587976.png

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 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.

PDM83_2-1691161981689.png PDM83_3-1691162592741.png


It is as if most projects 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.




Super User
Super User

The limits are here : 


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.

View solution in original post

Super User
Super User

The limits are here : 


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.

Regular Visitor

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?

Super User
Super User

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.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors