Combine state code and country name in one field to display on power bi map visual

[Jilanibasha]

Hi Team,

I have 3 tables Participant, State and Country. I need to display state wise participant count on map visual. The problem is i have only state code(WA,TN etc). if i take map on state code, It is pointing worng places for some state codes. Reason might be the same state code might available in other countries also. so my requirement is i need to combine my state code and country name in one field to display on map.

I have created new field with concatinate of state code and country name (ex: TN, United States, WA, United States and QC, Canada)

when i try to dispaly count with combination field, map not showing any data 

Please suggest how to display data with state code and country name combined field

[lbendlin · Accepted solution]

Power BI allows you to help it by categorizing certain columns.  When you do that it makes it easier on the geocoding algorithms.

No need to concatenate etc.