Skip to main content
Microsoft Idea

Power BI

Under Review

New regional or fill map object needs help

Vote (3) Share
Eric Vogelpohl's profile image

Eric Vogelpohl on 03 Feb 2015 22:32:56

Got data for all counties in New York. I tried to create a map to shade the counties by the value. However, the new mapping feature doesn't know what counties are in New York. It's best guess put Albany in Wyoming and a few in Germany.

The UI needs to allow users to set what is being geo-located. Since the field for Location is a multi-value field, it would make sense that I could define "State" to equal a State value and "County" to equal the fill-column. This would put Albany county back in New York.

Comments (1)
Eric Vogelpohl's profile image Profile Picture

Jon Fortner on 05 Jul 2020 22:43:25

RE: New regional or fill map object needs help

If a user puts Country, County/Province, and City in the Location field, Power BI should be able to locate it right. BUT, I found that I have to use a DAX formula to concatenate these together and use that. Power BI should do this in the background when those element are properly typed in the data.