Forum Discussion

Pmorg73's avatar
Pmorg73
Icon for Post Patron rankPost Patron
7 years ago

Bing Maps in MS Teams?

Hi I have two quick queries using the built in Maps   I am based in NZ and Bing often thinks that the address is in USA. Our address field often includes a post code, but can I direct the report to...
Need Help
Pmorg73's avatar
Pmorg73
Icon for Post Patron rankPost Patron
7 years ago

 

Anonymous wrote:

Hi Pmorg73 

For the first issue, always add the country name "New Zealand" to the location column.

Also define the appropriate data category, under modeling menu item.

Cheers!
A

Thanks. I will get funny looks from the admins if I ask them to add NZ to all the addresses. And alas only 98% of the jobs are in NZ, but yeah I could just do a column with all NZ entered. Might try that for the majority.

 

I have made the category "address" already.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Pmorg73 

You can add it as a custom value. Users/Admins do not need to change their work.

Had a similar issue in Australia and that solved it all.

Cheers!
A

  • Pmorg73's avatar
    Pmorg73
    Icon for Post Patron rankPost Patron
    7 years ago

    Could you expand? Where would I put the Custom Value?

     

    I added a "measure" column to my table that entered Location New Zealand for every entry. Blue cross in image. I then added it to the field list for the map. But as you can see it is not making the addresses move from across the globe?

     

    If I individually google the address then it finds most of them where I would expect, but the Bing map is not looking locally to us in NZ.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hey Pmorg73 

      Not sure why you have created a measure.

      I have created a column that looks like:

      Full Address = 
CONCATENATE (
    Table[Address],
    CONCATENATE (
        ", ",
        CONCATENATE (
            Table[City],
            CONCATENATE (
                ", ",
                CONCATENATE (
                    Table[State],
                    CONCATENATE (
                        ", ",
                        Table[Country]
                    )
                )
            )
        )
    )
)

      You can create something similar, maybe simpler.

      And in the country just hard code NZ.

       

      Or give a sample of your data, and we'll try to sort this issue out.

       

      Cheers!
      A

      • Pmorg73's avatar
        Pmorg73
        Icon for Post Patron rankPost Patron
        7 years ago

        thanks for helping.

         

        I added a concantenate measure so address plus " New Zealand"

         

        Is it me or is Bing is useless? See the image. The Location clearly says what I want. Address plus NZ. But Bing puts in near Copenhagen? If you google the address. Perfect Map. 

         

        Suggestions?