Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Custom map in powerbi

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 y...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

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's avatar
    Anonymous
    Not applicable
    7 years ago

    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