I'm trying to visualize data across various counties and I'm running into an issue where certain states are being filled in on top of their respective counties. The odd part is this is only happening in Iowa and Minnesota, while the other state's data is formatted in the exact same way ("County,ST") with no issues. The GIS map also works with no issues, but I'd like to see if I can get the native filled map working so I have the option of choosing between the two. Does anyone know what's going on here? I've included a screenshot below for reference. All help is appreciated, thanks to everyone in advance.
Hi. I was facing the same issue, except not in Iowa/Minnesotta but in Maryland. Try changing the data category of field you are using in the location well to 'Place' instead of 'County' in the 'Column Tools' tab. That did the trick for me. The counties are not overlapping anymore. I guess Power BI interprets 'Place' as more specific location than 'County'.
P.S. : I realize that the question is more than 2 years old. Still posting my response as it could be found useful by someone else who stumbles into the same issue. Cheers. 🙂