Forum Discussion

Qualube's avatar
Qualube
Helper II
8 years ago

MAPS

Hi

Not sure if anyone can help I have a customer list I have imported from an excel spreadsheet into a map in Desktop Power BI.

All the customers have appeared except those in EIRE (Southern Ireland) and New Zealand.

I have set the location to postcode as 99% of the customers are in the UK however I can't get these remaining small number to appear.

Is there a way of including them??

 

Thanks

5 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    Hi Qualube,

     

    Which map do you use in Power BI?

     

    I have made a test with ArcGIS Maps for Power BI, which works as expected.

     

     

    Please have a try with ArcGIS Maps for Power BI.

     

    If you still need help, could you share a dummy pbix file which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

     

    Best  Regards,

    Cherry

    • Qualube's avatar
      Qualube
      Helper II
      8 years ago

      Hi Cherry

       

      Thanks so much for your reply I am using the standard map visualisation but using the postcode as the location value so the customers that are outside the UK which don't have postcodes aren't displayed.

      The same happens with the ArcGIS map, I know why it's happening but not sure how to solve it.

       

      Mick

      • v-piga-msft's avatar
        v-piga-msft
        Resident Rockstar
        8 years ago

        Hi Qualube,

        but using the postcode as the location value so the customers that are outside the UK which don't have postcodes aren't displayed.

         

        If I understand your scenario correctly, you want to show the customers outside the UK which don't have postcodes?

         

        If you don't have post codes,  you can’t locate it on the map.

         

        As a workaround, you could set the default postcodes for the customer outside the UK which don't have postcodes, then it will show the default location on the map.

         

        Best Regards,

        Cherry