Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filled Map - Group Multiple Zipcodes to SubRegions

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.png

 

Thanks! 

Any solutions? 

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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.