Skip to main content

Power BI

New

Mapping Visuals Should Send All Location Data to the Bing Service

Vote (79) Share
Matt Allington's profile image

Matt Allington on 14 Dec 2017 04:38:51

If I add a list of State codes to the location card on a map, the results will normally not be accurate. The States selected could be from anywhere in the world - if you don't add the country details first, you get inconsistent results. There is a work around that can be achieved by adding the Country and State to the location section like this

Country
State
Address

You can then click Expand All Down to get the fully qualified state and address WITHIN the correct country. While this works, it is inconvenient and I think there is a better way.

I would like to see the following. If I have the following Columns in my data model:

Address, State, Post Code, Country

And assuming they are all categorised correctly using Data Category, then these columns should be sent to the Bing Service regardless if they are added to the visual or not. So if I put Address onto the map, I would like the full set of categorised columns that exist in my table to be sent to the Bing Service even though State, Post Code and Country are not actually placed in the visual. This would greatly increase the usability and accuracy of the mapping visuals

Comments (2)
Matt Allington's profile image Profile Picture

23309802 5327-4608-9a85-757be45ca59b on 05 Jul 2020 23:25:09

RE: Mapping Visuals Should Send All Location Data to the Bing Service

Agree, behaviour can be improved.

Matt Allington's profile image Profile Picture

3b7151a8 7110-4e5e-b9e7-baae8aa49a46 on 05 Jul 2020 23:07:21

RE: Mapping Visuals Should Send All Location Data to the Bing Service

It would be a little better if you could just give Bing maps some constraint. If it's ambiguous, I'd like to tell it to choose Canada instead of USA, for example. Quick n dirty map demos never work well unless you use American addresses.