Custom map in powerbi

[Anonymous]

Hi all, 

I've been working on PowerBi for a month so far, and I'm almost able to do everything I need. However, there's something I'd like to do, and I'm not sure if it's possible.

Let me give you an easy example so you can easily what I'm looking for:

Example of data:

Country	Sales
Sweden	84
Norway	21
Denmark	3
China	15
India	35
Brazil	15
Argentina	25
USA	31
Canada	30

This is an example of the map we could do.

Now, what I would actually like to do is to gather some countries according to our criteria. For example, I would need Sweden, Norway and Denmark together, then France and Germany together and so on. 

The idea would be that in the end, Sweden, Norway and Denmark have the same color in the map, only one circle (which would be at the central position between the 3 countries) to show the data and same for other group of countries. Is that possible? If yes, how to do it? 

Thanks a lot for your help,

Valentin.

[v-frfei-msft]

Hi @Anonymous ,

We can achieve that by creating a calculated column.

Kind = IF([Country] in {"Sweden", "Norway","Denmark"},"A",IF('Table'[Country] in {"France", "Germany"},"B","C"))

[Anonymous]

Hi @v-frfei-msft,

Thanks a lot for your reply,

My issue with your solution is that there are several circles instead of one single circle per region.

Let me show you what I'm looking for:

Of course, there would be many more regions and it wouldn't be done on paint.net so it would be much more beautiful but that's the idea.

It could either do circles with the same color (like in the example) or countries that are filled with the same color.

Thanks again for your help,

Valentin