Forum Discussion

KossithAz's avatar
KossithAz
Icon for Helper I rankHelper I
2 years ago

Map isn't being filled with post code data (UK)

Hi folks,

I have a dataset of 170+ rows on people's information and this includes their postcode (but not address, just postcode). 

I've tried looking through previous posts but seem to find no solution.

I've tried changing the data category from place, to address, to postal code, nothing works.

I've tried two formats such as 'WR1 2AB' and 'WR12AB' but either work. When I add the data onto the map, it just shows the entire globe. When I zoom in on my specific area, nothing is filled out.

Any help would be really appreciated!

5 Replies

  • PijushRoy's avatar
    PijushRoy
    Icon for Community Champion rankCommunity Champion

    Hi KossithAz 

    You can try Approach 1
    Concatenate UK before your postal code and try to place on MAP

    Approach 2
    Create Static lookup table and merge with main table
    Lookup table should show State & Dristic of Postal code
    Concatenate as follow
    UK & State & Dristrict & Postal Code
    How to generate UK state & dristrict

     

    Approach 3
    Download UK Postal Code Dataset and use same mentioned in Approach 2




    Let me know if that works for you


    If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

    • KossithAz's avatar
      KossithAz
      Icon for Helper I rankHelper I

      Hi Pijush,

      I've attempted approach 1, sadly no luck.

      Tried approach 2 (address 1, 2, town, postcode, UK), still no luck.

      Approach 3 has the above details, still no luck...

      The only thing that's worked is:

      1. Using just the postcode with data category as 'Place' just covers 1 small part, showing 1 postcode, rather than a collection.

      Nothing else seems to work 😞



      • PijushRoy's avatar
        PijushRoy
        Icon for Community Champion rankCommunity Champion

        Hi KossithAz 

        Can you please share sample data or create a pbix file and share the link (sample non sensitive postal data and value)

  • kleigh's avatar
    kleigh
    Icon for Responsive Resident rankResponsive Resident

    The maps will geocode UK postcodes to points, but not filled areas. If you want filled areas, you have to provide your own polygons. The ONS ran a session on this recently, but it seems the VOD is not up yet.