Forum Discussion

afrutos's avatar
afrutos
Resolver I
2 years ago
Solved

Shape map tieh text fields

I have a table in PowerBI, wich has a column with Countries and another column with Entity type (DyL, L or D).
I am using a shapemap visualization. 
In location: country
In Legend: entity type
In color saturation: entity type

And the countries that have D are shown to me, those that have D&L too, but those that have G, no.

I think it is because, for example, Brazil has another line whose entity type is L.
What can I do?

 

  • Go to your visual gallary and select a different map styly I am using the one below

     

     

     

3 Replies

  • Go to your visual gallary and select a different map styly I am using the one below

     

     

     

  • Yes you are correct since you are using a shaded map it will take the first value to color code the map.  You can combine them into one so like D, L is one color when is both or not sure if they should be part of DyL in the case they would need to be converted. 

    or you can use a map which show a pie chart with the color the two color values

     

    • afrutos's avatar
      afrutos
      Resolver I

      Could you please show me how did you do these pie chart in brasil? I'm trying but getting nothing