Forum Discussion
Region modeling
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...
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.