Counting 'bubbles' within shape on map

[Bruce_B_84]

Hi there! I've successfully had a spreadsheet map 1,500 bubbles on a map all through Australia.  I now would like to draw a shape, in a small area (say for example, a 400m circle, or a 800m circle - and for BI to tell me "how many bubbles within that circle.

To get more advanced, I would like to trace around a suburb - and then - get it to tell me how many bubbles in the vector shape I created.

Is there an easy way to "draw on the graphic" using a tool and then have it give me the number of bubbles within that shape?

[Anonymous · Accepted solution]

Hi @Bruce_B_84 ,

According to your statement, you want to draw on map visual and then count the number of bubbles within the shape you draw.

Your demand is a good idea, while it is not supported to implement in Power BI currently.
You can submit a new idea to improve the Power BI.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

As far as I know, map visual in Power BI will determind the position of each bubble by location or Longitude&Latitude. So I suggest you to determind the position of each bubble by Longitude&Latitude and create slicers for Longitude&Latitude. Table should look like as below.

Then count the bubbles in the range of Longitude&Latitude slicers.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.