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
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

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