Map Visual: conditional formatting for bubbles

[Tomas930115]

Hi,

I have a map with many bubbles that represent businesses. Each bubble has a different color and I would like to have a conditional formating where the businesses that have positive profitability are green and others are red. I saw some solutions that you can do it manually, however for my case, it is unsuitable. 

Thank you for the advice

Tom

[djurecicK2 · Accepted solution]

Hi @Tomas930115 ,

 Click the fx icon next to the color dropdown and then you have a lot of different options for setting the colors, including rules. So you can set a rule where profitable= green and non- profitable= red.

[Tomas930115]

I have moved the name of the business to the tool tip and now it works as well. I can have conditional formating and the legend when i hover mouse over it. Thank you 

[Tomas930115]

This option is only available when i have nothing in the section "legend". However i have in the legend name of the businesses and it allocates them the color and there is no option for conditional formating

[Idrissshatila]

Hello,

Check this link that would show you how to make a conditional formating, you will aplly it on the value measure you're using.

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos👍

Follow me on Linkedin