Forum Discussion
Filled map and UK Postcode Area - not working (but Postcode District is)
Hi s--turn,
It seems like Power BI may not be recognizing your Postcode Area column as geographic data. One potential solution could be to try adding a custom geographic hierarchy to your data model that defines the relationship between Postcode Area and other geographic areas, such as counties or regions.
To do this, you can go to the "Modeling" tab in the Power BI ribbon and click "New Hierarchy". Then, select your Postcode Area column and choose which other geographic columns you want to group it with (e.g. county, region, etc.). Once you have created the hierarchy, you can use it to create your filled maps and color them according to the number of people in each Postcode Area.
If this doesn't work, it could be worth checking if there are any formatting differences between your Postcode Area and Postcode District columns. For example, if one is formatted as text and the other as a number, this could cause issues with Power BI recognizing them as geographic data.
Best regards,
Isaac Chavarria
If this post helps, then please consider Accept it as the solution and give Kudos to help the other members find it more quickly.
Hi ichavarria , thank you so much for your response. Unfortunately, I haven't had any luck with it. Both fields were formatted as text, so that's not the cause. I tried creating a hierarchy, putting Postcode Area under Country (since I've noticed it does occasionally pick up regions in other countries, where they coincidentally have the same abbreviation as a Postcode Area), but this didn't work for me either - if I left Country in, it just shaded the entire United Kingdom, and if I deleted Country, it still didn't recognise any Postcode Areas (in this example, I would expect it to shade certain areas in Scotland, as the visual is filtered on people who belong to one of our Scottish groups) - see screenshots below:
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.
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!
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.
