How to merge districts/cities at one using choropleths/filled maps

[glauberdmo]

Hi PowerBI community!

I`d like to merge regions from map to assign a value, so as result there isn't a division between the states: Rio de Janeiro/São Paulo/Minas Gerais/Espirito Santo, but Region southeast instead (such as example). The many places doesn't make sense to analyze unmerged. thoses states joineds will be a single map shape. This happens in another levels too.

Glad for any help! Even whether or not possible to make it.

[v-sihou-msft · Accepted solution]

@glauberdmo

We can't directly custom a Region level between Country and State level. But you can add a Region column and drag it into Legend.

To analyze data on Region level, you can add measure/calculated column to have your calculation group on Region column with ALLEXCEPT() function.

Regards,