How to create DMA(Designated Market Area) bubble map

Hi DataTurtle 

• For your first question :Multiple Bubbles for the Same DMA

If you're seeing separate bubbles for states within the same DMA, it's possible that the data model or the visualization settings need to be adjusted to aggregate the data correctly. Here's what you can do:

1. Check the Data Model:

Ensure that your data model has a single row per DMA with the aggregated values you want to display.

If necessary, use Power BI's query editor to group your data by DMA and aggregate other columns as needed.

2. Adjust Visualization Settings:

In the Format pane of the bubble map, make sure that the data field for the location is set to the DMA level, not the state level.

Check that the values for the size of the bubbles are aggregated correctly (e.g., sum, average) based on your requirements.

• For your second question : DMA Name Conflicts with City Name

When a DMA shares the same name as a city, Power BI might be incorrectly geocoding the location to the city rather than the DMA. To resolve this:

1. Refine Location Data:

Include additional location fields in your dataset that can help Power BI distinguish between the city and the DMA (e.g., state, region, or country).

2. Customize Geocoding:

If you have latitude and longitude coordinates for your DMAs, use those fields in your map visualization to accurately plot the bubbles.

Alternatively, consider creating a custom map with the Shape Map visualization if you have the GeoJSON or TopoJSON file for your DMAs.

3. Check the Data Category:

In the Data pane, make sure that the data category for your DMA field is set appropriately (e.g., to "Place" or "City") to help Power BI understand the type of location you're working with.

For more detailed guidance on creating maps in Power BI, please refer to the official documentation on map visualizations:

Create and use filled maps (choropleth maps) in Power BI - Power BI | Microsoft Learn

^{Best Regards,}

^Jayleny

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