Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Change bubble colors based on category on map

Hi all,

 

I am trying to change the colors of the bubbles on a map on power bi. On the screenshot below I have the Change Sign column (it's a column saying if a change is positive or negative) and I want to change the color of the bubbles based on this. Red for negative and Blue for positive.

 

Can you help?

 

 

 

Thanks!

Need Help

2 Replies

  • mussaenda's avatar
    mussaenda
    Icon for Community Champion rankCommunity Champion
    7 years ago

    You can change the color using conditional formatting.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks, I could not figure out the conditional formatting as it changed the value field to Latitude automatically and would not keep change.

       

      But I could change the bubbles color based on the field by going to data colors, selecting the field Change Sign and theyn positive and negative would appear there and I could change the color independently.

       

      Thanks!