Forum Discussion
uk postcode
Hi pgladwin,
Could you please share some data sample here, regarding the postcode district?
Filled map uses bing map to generate, Bing Maps uses the field in the Location well to create the map. The location can be a variety of valid locations: countries, states, counties, cities, zip codes or other postal codes etc. Bing Maps provides filled map shapes for locations around the world. Without a valid entry in the Location well, Power BI cannot create the filled map.
Check the article below:
Regards
Thanks for your reply.
I need to plot a filled map using the UK postcode system.
A valid postcode is: BS8 2NW.
The first letters or letter is called the area code, e.g. BS
The first section (before the space) is called the postcode district e.g. BS8
The first character after the space is called the postcode sector, BS8
I don't know what the next level is called but it is useful to plot nonetheless e.g. BS8 2N. I call it sector plus 1.
My question is how can power BI plot each of the above in separate filled maps?
Here is some dummy data for the County of Kent:
| Postcode | County | Value |
| BR6 7JT | Kent | 2 |
| CT1 1PF | Kent | 4 |
| CT12 5JB | Kent | 6 |
| CT13 9JW | Kent | 8 |
| CT14 7BA | Kent | 10 |
| CT15 7HG | Kent | 12 |
| CT16 1HU | Kent | 14 |
| CT17 9DP | Kent | 16 |
| CT6 6SS | Kent | 18 |
| DA12 2BH | Kent | 20 |
| DA4 0AA | Kent | 22 |
| ME1 1SW | Kent | 24 |
| ME13 8RX | Kent | 26 |
| ME17 3LW | Kent | 28 |
| ME19 6PD | Kent | 30 |
| ME2 2AH | Kent | 32 |
| ME20 7DE | Kent | 34 |
| TN15 0QX | Kent | 36 |
| TN26 2AL | Kent | 38 |
| TN29 0NL | Kent | 40 |
| TN3 8LP | Kent | 42
|
| Area Code | County | Value |
| BR | Kent | 20 |
| CT | Kent | 30 |
| DA | Kent | 40 |
| ME | Kent | 50 |
| TN | Kent | 60 |
| District | County | Value |
| BR6 | Kent | 10 |
| CT1 | Kent | 20 |
| CT12 | Kent | 30 |
| CT13 | Kent | 40 |
| CT14 | Kent | 50 |
| CT15 | Kent | 60 |
| CT16 | Kent | 70 |
| CT17 | Kent | 80 |
| CT6 | Kent | 90 |
| DA12 | Kent | 100 |
| DA4 | Kent | 110 |
| ME1 | Kent | 120 |
| ME13 | Kent | 130 |
| ME17 | Kent | 140 |
| ME19 | Kent | 150 |
| ME2 | Kent | 160 |
| ME20 | Kent | 170 |
| TN15 | Kent | 180 |
| TN26 | Kent | 190 |
| TN29 | Kent | 200 |
| TN3 | Kent | 210 |
| Sector | County | Value |
| BR6 7 | Kent | 2 |
| CT1 1 | Kent | 4 |
| CT12 5 | Kent | 6 |
| CT13 9 | Kent | 8 |
| CT14 7 | Kent | 10 |
| CT15 7 | Kent | 12 |
| CT16 1 | Kent | 14 |
| CT17 9 | Kent | 16 |
| CT6 6 | Kent | 18 |
| DA12 2 | Kent | 20 |
| DA4 0 | Kent | 22 |
| ME1 1 | Kent | 24 |
| ME13 8 | Kent | 26 |
| ME17 3 | Kent | 28 |
| ME19 6 | Kent | 30 |
| ME2 2 | Kent | 32 |
| ME20 7 | Kent | 34 |
| TN15 0 | Kent | 36 |
| TN26 2 | Kent | 38 |
| TN29 0 | Kent | 40 |
| TN3 8 | Kent | 42 |
| SectorPlusOne | County | Value |
| BR6 7J | Kent | 2 |
| CT1 1P | Kent | 4 |
| CT12 5J | Kent | 6 |
| CT13 9J | Kent | 8 |
| CT14 7B | Kent | 10 |
| CT15 7H | Kent | 12 |
| CT16 1H | Kent | 14 |
| CT17 9D | Kent | 16 |
| CT6 6S | Kent | 18 |
| DA12 2B | Kent | 20 |
| DA4 0A | Kent | 22 |
| ME1 1S | Kent | 24 |
| ME13 8R | Kent | 26 |
| ME17 3L | Kent | 28 |
| ME19 6P | Kent | 30 |
| ME2 2A | Kent | 32 |
| ME20 7D | Kent | 34 |
| TN15 0Q | Kent | 36 |
| TN26 2A | Kent | 38 |
| TN29 0N | Kent | 40 |
| TN3 8L | Kent | 42 |