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

[KossithAz]

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!

[kleigh]

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.

[PijushRoy]

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]

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]

Hi @KossithAz 

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

[KossithAz]

200052252 110032530 110025608 110025608 110025644 201010992 200035449 110033976 110025608 200035449 201024349 110025644 200097489 200097489 130007168 110025644 110025608 110032530 200020448 110032530 110034338 130120234 200039445 110025608 201010992 201010992 110157466 201010992 120682073 201010992 110025644 200097489 110025644 201010992 110025644 110157466 110025644 130155277 110032530 110045983 110032530 200097489 110032530 110025608 130028357 130102187 110025608 110025608 130120234 201010992 110025608 200039445 130102187 201010992 200039445 110025644 130102187 110147357 200039445 110157466 201010992 110025644 201010992 110025644 201010992 120739132 110025644 200169788 201010992 130075084 201010992 201012864 201028005 200039445 110025608 110071359 200020448 110054861 130160153 130138990 110045983 110005304 110036237 110034572 110034523 110034482 110002873 110002534 110034396 130036477 110034392 130031673 130031271 130031268 110002873 130031224 130031268 130028203 110033151 130036477 130026083 130023905 130044919 130023815 130023459 110002652 110002508 110002018 130099879 130102187 130135410 130138990 130023242 130022931 130022123 130019555 130019555 130019374 200035449 130017217 130016649 110032530 110022165 110002597 130016626 201012864 130016626 130015411 130009063 110019438 130008112 130008112 130006636 110019164 110002597 110002153 130006636 200298868 130002995 130001206 200187433 121554564 110017960 200156656 200145809 121032056 200270880 200270880 200321240 200123552 200108190 120757886 120708739 110015555 110002571 200097489 200097211 200094670 200088309 120708739 200082586 200069254 200069254 200054877 120657678 110015502 200051657 200051657 201029670 201031784 110095681 110007438 110002534 110002018 110001824 110001704

WR3 7BY B61 7BJ WR14 1TR WR14 1TR WR14 2DA WR9 0AG DY10 2LE B97 6RL WR14 1TR DY10 2LE B98 8HF WR14 2DA DY11 7AE DY11 7AE WR3 7BY WR14 2DA WR14 1TR B61 7BJ WR1 3HZ WR11 3AL WR13 6AS WR9 8WD WR9 0AG WR14 1TR WR9 0AG WR9 0AG WR11 2LF WR9 0AG WR2 5RR WR9 0AG WR14 2DA DY11 7AE WR14 2DA WR9 0AG WR14 2DA WR11 2LF WR14 2DA DY10 3BN B61 7BJ WR11 4TJ B61 7BJ DY11 7AE WR11 3AL WR14 1TR B61 7BJ WR11 3AL WR14 1TR WR14 1TR WR9 8WD WR9 0AG WR14 1TR WR9 0AG WR11 2LF WR9 0AG WR9 0AG WR14 2DA DY11 7AP B61 0BJ WR9 0AG WR11 2LF WR9 0AG WR14 2DA WR9 0AG WR14 2DA WR9 0AG WR11 2LF WR14 2DA B97 5BN WR9 0AG WR13 6SB WR9 0AG SY3 8BD WR11 3AL WR9 0AG WR14 1TR B97 6EH WR1 3HZ WR11 7HA B97 4NP DY10 2RQ WR11 4TJ WR8 0AA WR14 4RG WR8 0AA WR5 3EU WR14 4RG WR13 5AD WR3 7BY WR13 6SB B97 6EH WR3 7BY B98 8QG B60 1BX B98 7SL WR13 5AD B97 6RL B98 7SL DY11 5BJ B61 8LB B97 6EH B98 0AB B98 0AU B61 0AR B97 5PB DY13 9JG WR14 1TR WR4 9ST WR6 5NE DY13 9JH DY11 7AP WR9 7JJ DY10 2RQ DY11 6AP DY13 0TL DY10 3UD DY11 6AP DY11 6AP DY11 6BS DY10 1SP B97 5LX WR13 5AD WR9 8WD WR14 2DA WR6 5NE DY10 4JJ SY3 8BD DY10 4JJ DY10 1NG DY10 2LE B60 1BX DY10 3UD DY10 3UD B97 5LX WR9 7JJ WR6 5NE WR11 2LF B97 5LX WR14 4RG B61 8LB DY9 0NX DY9 0NX B60 2NQ WR4 0SB B98 8QE B98 7NP DY10 2XT DY13 8AL DY13 8AL DY11 7NX WR9 8TE WR11 2SH DY11 5BJ DY10 2TJ WR13 6SB WR11 2SH DY11 7AE B98 8QZ DY10 1RR DY13 9JH DY10 2TJ B98 8HF DY10 3NQ DY10 3NQ DY10 1SG WR9 8TE WR14 4LF DY10 2LE DY10 2LE WR11 2AY WR9 8TE WR14 2DA B61 7NJ WR3 7BY WR6 5NE DY13 9SD WR4 0SB

Sorry about the formatting, but this is my dataset, the identification number and the post code.