Forum Discussion
Power BI Map Help
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?