Forum Discussion

W2SANC's avatar
W2SANC
Helper II
1 year ago
Solved

Power BI Map Help

Hello!    I am reaching the Power BI delierium stage of knowing the solution is likely really simple (and my error is silly). Please help me regain my sanity.    I have a dataset that basically s...
Need Help
  • v-venuppu's avatar
    v-venuppu
    1 year ago

    Hi W2SANC ,

    May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

    Thank you.

anilelmastasi's avatar
anilelmastasi
Super User
1 year ago

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. ✅

 

W2SANC's avatar
W2SANC
Helper II
1 year ago

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?