Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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 s...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    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:

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

my data

 

map

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Here are my images:

  • Sean's avatar
    Sean
    Community Champion
    9 years ago

    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:

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Sean

      Thanks for help! I was able to setup the map and Matrix Preview as well. :smileyhappy:

    • joeality's avatar
      joeality
      Frequent Visitor
      7 years ago

      Sean, 

      I'm having the same problem but I don't understand how you two solved the problem. Would you mind explaining it to me again. 

       

      I have our company information set in region data and I need to assign those regions to countries. I have a separate .xls file with the headers "Country", "Region", and "Area" and the Region and Country are different types of grouping. How do I get the map to draw on this file?