Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Counting 'bubbles' within shape on map

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 - ...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    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.