Scatter Chart Color plot

[Saipreethi]

Hi Everyone,

When I select a country in slicer then it should plot one color(Black) in the scatter chart with bubble, When I select more than 1 country it should plot with black color for selected countries and unselected countries needs to be in Blue color. But In my case when I select single country it is showing as black color and when I select more than 1 country it is turning out into blue color(selected countries) and unselected countries are changing into black. I want it to be reverse. Can anyone help me with the measure please.!

[amitchandak · Accepted solution]

@Saipreethi , 2 things are required. One is you are not using legend in the visual, second, the company slicer need to come from an independent table. Then create a color measure

measure

if(max(Table[Country]) in Values(Country[Country]) , "Black", "Blue" )

if needed use isfiltered to check if data is filtered or not

Use this in conditional formatting using field value option

Need of an Independent Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...

[Saipreethi]

It works!! Thank you so much