Forum Discussion
Zip code bubble map -- merge bubbles
I'm mapping inventory as count of widgets per zip code. Right now I have many bubbles across the map, each bubble representing a zip code's # of widgets. Is there functionality in Power Bi to combin...
You can create a calculated column or "new group" on city column for your "Area".
Then put this Area field into your geography hierarchy as well.
Regards,
Thanks for the suggestion! So it's a matter of manually aggregating (grouping) cities, which I could also do by including an additional field in the data such as "subregion" or similar". I was asking if there's a way to automatically merge based on geographic proximity, clustering similar locations together (particularly as you zoom out on the map view). It appears this is not current functionality available.
This functionality needs to be added. Bubbles should merge and separate based on the zoom level of the map. The typical zoomed out map of the US is not as useful as it could be.
