Forum Discussion
Map Visual: conditional formatting for bubbles
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
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.
4 Replies
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👍
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.
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
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
