Filled Map - Group Multiple Zipcodes to SubRegions

[VicJ]

Hi Community, 

I'm building up a heat map for Belgium based on zipcodes. Unfortunately the map gives me a "too of a micro" scale. Is there  anyway I can group multiple smaller regions into one and still identify them on the maps? 

I tried the basic grouping functionality in Power BI, however Power BI does not identify the areas on the map anyway.

I am looking for something like this: 

https://en.wikipedia.org/wiki/List_of_postal_codes_in_Belgium#/media/File:2_digit_postcode_belgique....

Thanks! 

Any solutions? 

[Anonymous · Accepted solution]

Hi,

There are several ways to do this.
The most straigt forward one, is to create a dimension with the data PowerBI does recognize.

In my example I used the city names for PowerBI to recognize.
If you then drag the short postalcode to legend, it will color on that level.

Hope this helps!

Robbe

[VicJ]

Thanks for the suggestion. Does this also allow me to make a heatmap out of this? As it is now, I only get different colors per regions. However my regions have a certain achievement in %%. I want to create a heatmap based on that.