Forum Discussion

dogburalHK82's avatar
dogburalHK82
Helper III
2 years ago
Solved

plot map with value legend

Hi,    With the attached raw data, i would like to make a map like below.   How should I set up to get that region associated with the prevalence value?   Country Population Region ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi dogburalHK82 ,

     

    Thanks PhilipTreacy  for the quick reply. I have some other ideas:

    (1)We can create a Filled Map->Changing the fill color.

    (2) We can create a rank column.

     

    rank = IF([Estimated prevalence of modern slavery per 1,000 population]<> BLANK(), RANKX('Table',[Estimated prevalence of modern slavery per 1,000 population],,DESC,Dense) ,BLANK())

     

    (3)Then the result is as follows.

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

PhilipTreacy's avatar
PhilipTreacy
Super User
2 years ago

Hi dogburalHK82 

 

What you've shown in the image and what you are asking for are different.  The map shows values plotted against countries, not regions.

 

If you import that data into PBI (via Power Query) and create a filled map, you get this

 

 

Do you want the data plotted aginst countries or regions?  As a heatmap (varying shades of the same/similar colour) ?

 

Regards

 

Phil

  • dogburalHK82's avatar
    dogburalHK82
    Helper III
    2 years ago

    PhilipTreacy my bad - I typed wrong... supposed to be legend (not region).

     

    Like you said, the plot againt country with the legend varying shades of the same/similar colour.