Azure Map filled postal codes (layered?) issue

[ddk]

Hi all,

I created a filled map (Azure Map visual), based on Belgian postal codes and a value for each.

The conditional formatting is based on a field value from a column in the table which contains colour codes for the postal codes (based on the value).

It looks ok (all relevant Belgian postal codes are nicely filled), but when checking some details it appears that some postal codes are "layered on top of each other".

In some cases, 1 filled postal code region on the map references 2 or 3 postal codes in the table. And the color is taken from one of those. 

They are sort of related, as mostly it is 1 main postal code and the others are "submunicipalities", but they are officially recognised as seperate postal codes (also on Bing Maps). Other submunicipalities do get shown as seperate areas.

So, why doesn't the Azure Map recognise these as seperate regions on the map?

It seems like it does understand that they are related (by layering them), but it shows them on the same region.

Anyone seen this "issue"?

What could be a workaround?

EDIT:
I just found out that all postal codes are recognised when activating "Bubble layer".
But the Filled map is grouping them...?

EDIT 2:
The Filled Map visual seems to do the job, but has less formating options (and Azure Maps seems to be the way to go😞

[Anonymous]

Hi,@ddk 

Regarding the issue you raised, my solution is as follows:

1.First I have created the following table and the column names and data are the data you have given:

I populate the azure map view with the corresponding values:

And change the corresponding area code to the color you set:

Here are the best results from my practice:

2.I suggest you also try ArcGIS maps, here are the links to the relevant documentation:

Create an ArcGIS map in Power BI - Power BI | Microsoft Learn

3.Here is a link to the relevant document, hope it helps:

Azure Maps Documentation | Microsoft Learn

Get started with Azure Maps Power BI visual - Microsoft Azure Maps | Microsoft Learn 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.