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.