Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
pbi_newbie222
Frequent Visitor

First two digit labels in Azure Maps

Hi,

 

I have trouble creating a Azure map which shows Germany divided into areas based on the first two digits of german zip codes.

Later on, I want to fill these areas based on a measure.

For this, I created a Azure map and put the zip codes into the Location.

However, it does not recognize these first two digits as german zip codes and shows the areas in Columbia. That is why I added an additional Country column in the Location with the value "Germany".  When drilling down with showing all element on the next level in the hierarchy, it works.

If I drill down to the lowest level directly, again, it shows Columbia.

However, I want the labels to only show the digits and remove the label of the Country hierarchy level (see Screenshot).

Is this possible? Or are there other ways to achieve what I want?

 

pbi_newbie222_1-1714394922732.png

 

 

2 REPLIES 2
Anonymous
Not applicable

Hi @pbi_newbie222 ,

To accurately represent the German postal code area. Azure Maps offers a geocoding service that converts addresses to latitude and longitude coordinates.

Below is the official link will help you:

Search for a location using Azure Maps Search services | Microsoft Learn

Best Regards,

Xianda Tang

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

Hi @Anonymous ,

sorry for the late response. Unfortunately, I am not able to use the Azure Maps service. Is there any possibility to solve this issue in Power BI itself?
For me it is hard to understand why I cannot adjust the hierarchy levels to show only the level I want or to make Power BI understand that these are german zip codes while having a filled Azure map.

Best regards

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!