Forum Discussion

s--turn's avatar
s--turn
Helper II
3 years ago

Filled map and UK Postcode Area - not working (but Postcode District is)

Hello,   For context, UK postcodes (e.g. NW2 5ND) can be broken down into different levels of detail.  The Postcode Area is the letter (or letters) at the very start (e.g. NW).  The Postcode Distri...
Need Help
d42UK's avatar
d42UK
Regular Visitor
3 years ago

I have this very same problem today and for the life of me I cannot work out the problem.

Did you have any success in fixing this?

The data is text, column set as geo address, and I've ensured there is no spaces before or after. I've disabled suspected features that have previously caused similar issues in the past.

s--turn's avatar
s--turn
Helper II
3 years ago

Hi d42UK , in the end I think I just had to use an Arc GIS visual instead of the native Power BI one. Weird and annoying!

  • d42UK's avatar
    d42UK
    Regular Visitor
    3 years ago

    Thanks s--turn . I managed to get something working last night by creating a full address column to get something to work.

     

    Full_Address = if(len('Table'[BillingStreet]) > 1,'Table'[BillingStreet]&", ","") & if(len('Table'[BillingCity])>1,'Table'[BillingCity]&", ","") & if(len('Table'[BillingState]),'Table'[BillingState]&", ","") &'Table'[BillingPostalCode] &", " &'Table'[BillingCountry]

     

    hopefully this helps others.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      How did creating a "Full Address" column helped? Did you have to format it as Geographic data? I was tempted to try ArcGIS Maps visual but because of its data sharing policy, I am not able to proceed, are ther any work arounds for using ArcGIS without sharing data? or any other solutions?