Forum Discussion
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...
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.
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?