Forum Discussion
customized region data type
Hi,
My organization uses custumized regions for management purposes. As an example we have one region called "Europe and Middle East" and "Asia Pacific". I need to create a map visualisation to show some data per region (organisation region). Is it possible to define custumized regions and link them to the real country names in order to have a map that shows our data per regions (same color for all countries that form one or regions), totals and legends to represented with our internal regions?
if yes, How can I accomplish this?
Thanks,
Zu
Anonymous
You can't use the Legend and Color Saturation at the same time!
Remove anything you have in the Color Saturation
Place New Golder Region in the Legend and leave Region in Location and whatever you have in the Size
Then click the Formating Paint Brush and this is where you can set the Data Colors
The Table Next to my Map is the Matrix Preview Visual showing the new Cross-Highlighting feature
This should work.
Let me know if you have any questions.
Good Luck! :smileyhappy:
6 Replies
Anonymous
If you have a region column in your data just place it in the Legend of a Map.
If you don't how you proceed will depend on how many countries you have.
You could use a SWITCH statement (nested IFs) to assign the regions
Or you can create the Region column in the Query Editor - Add Column tab - Conditional Column
and use the User Interface to create it - again it would depend on how many countries you have.
Or you can use another table for this to obtain the region...
Hope this helps!
Sean - Thanks for your reply! I'm new in Power BI so I'm don't know how to do some of this basic things. In my data table I have a column that is called region where I have a city country where the projects are located (see image data.png). I have a second column where I have my organization region (New Golder region) that I populated with a vlookup in Excel before uploading the data.
In my visualisation I added a map and attempt like you mentioned to add the region or my organisation region to the Legend field of map but it didn't accept any of this two columns in that field. Is there something wrong with the way I created the data.
Also how did you got the colors to be by region, I can only have colors by the number of sites in each region. See my image map.png
Also I tried to create a table of data next to the map as you did but is not connected to the map. How you did this? how did you got the countries and regions to show in hierarchical view in the table next to the map? .
Thanks,
Zu
