Forum Discussion
Power BI Map Help
Hello -
I have changed some of the relationship connections on the backend, and that has helped keep it within the US (yay!) - now my only question is - I was hoping to have the map that showed circles (where the larger the circle indicates larger $ deployed in that place). See in the attached photo that I currently have shaded in counties/places, and for my purposes, this isn't the most helpful visual. I also am not 100% what shaded means (darker color saturation = more $?)
Hello W2SANC ,
You are currently using Filled Map. Shading = relative intensity (darker = more $ deployed)
But what you want is Bubble Map. This is the standard “Map” visual, not the “Filled Map.”
You can swith to map with:
In the Visualizations pane, change from “Filled Map” to “Map” (looks like a globe icon 🌐)
In the Fields pane, configure it like this:
Location: County name
Size: $ Deployed (your numerical field)
Set Data Category on the Location column to “Place” or “County”
If this solved your issue, please mark it as the accepted solution. ✅
Thank you! I did that can got the visual results I wanted. BUT, there are still a few dots that show in other counties (see below photo).
I'm not sure how to fix those specific data points. See below. If I hover over those points, it still has labels as County, State in the US (example - Albermarle, Virginia)
Hello W2SANC ,
Create a calculated column that clearly identifies each location. Like below formula:
CountyState = [County] & ", " & [State]
-Use this column in your map visual’s Location field.
-This helps Power BI avoid confusion between counties with the same name in different states (e.g., there are 30+ Washington Counties in the US).
After that:
Select your CountyState column
Go to the Modeling tab > Data Category → Set to Place or County
If this solved your issue, please mark it as the accepted solution. ✅
Hello! Can you do a little bit more of a step by step on this part:
After that:
Select your CountyState column
Go to the Modeling tab > Data Category → Set to Place or County
Where do I select the county state column (County, State) ? in the modeling tab?