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:

     

Sean's avatar
Sean
Community Champion
9 years ago

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!

 

 

 

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: