Region modeling

[Elrobinho]

Hi everyone !

I've been stuck with a problem for days and can't find the solution, please help me 🙂 

I have a (large amount of) data pulled from a Sharepoint, showing among other things regions as follows: AMS, EMEA, APJ, WW

I would like to map that on Power BI, but "AMS" doesn't mean anything for Power BI or Bing. How can I model it? I have thought about the following paths:

- SWITCH function in a new column, but how should I call these regions? "Americas" also doesn't work for example

- Group many regions in one: I'm not sure of how to do that. I've tried to create a column South America and a column North America but don't know how to group them afterwards

- Create a continent and then put regions in it, somehow

Yours thankfully.

[danextian]

Perhaps you have a list of countries and their corresponding regions. You can map out those countries instead.

[Elrobinho]

Thank you for your answers, but I can't make it work with my data... Would you be able to give me steps to follow to get what you have on your screen? This would be great !

BR.

[dvstrien · Accepted solution]

Okay.... I'm trying to attach the pbix file but I can't see an attachment option! Aren't we meant to be able to attach files? 

Let me know if you can't access the file through this link. 

https://drive.google.com/file/d/18si89ZYVslOeMiKfOVHlP9aqxYpksPoO/view?usp=sharing

After my response yesterday I  actually came up with something I think is better which is using google maps to find out the  longitude and latitude of the point in the map where you want the circle to appear and creating a table that has that information. Then link that table to your fact table and off you go!

Both examples are in the PBIX file...

[Elrobinho]

That is amazing ! I'll try it when I'm back from vacation but it looks like it's exactly what I'm looking for thank you so much

[Elrobinho]

Hi, I have tried it and indeed, it works perfectly ! I've put bigger bubbles and it does the trick 🙂 Thank you so much

[dvstrien]

I don't think you can map this with the maps visualisation, unless you're able to find out exactly what Bing calls the regions that make up "your" region names (EMEA, APJ, AMS etc). Then you need to add a table to your model that "translates" your region names to the ones Bing uses. 

edit - Actually, you can do it with the map visualisation, I just had a play and came up with this: 

You can maybe use the custom visual called Synoptic Panel, which comes with an online designer tool which allows you to create areas on an image (i.e. a map of the world) and give them a name, those names should correspond with your region names. 

Alternatively, have a look into custom shape maps (shap maps are a preview feature that needs to be enabled). There are free maps available on the internet (koordinates.com has one available for the regions of the world) but you often have to tidy them up using mapshaper.org before you can use them in Power BI and unless you can find or create one that uses your region names, your model still needs to have a table that "translates" the region names of the map file to the names you have in your data.

[Greg_Deckler]

There is the ability to create groups in Power BI. If I remember correctly, not sitting at my computer, right click a column and choose New Group.