Skip to main content

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

23829ea9 271b-49ff-b7e1-df50fed2b62d 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.