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

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.