Change column color in a bar chart based on a slicer

[johndha]

Hello Everyone,

I have a simple table (Name, Value) , and I have a slicer with Name

Requirement: 

When I select a name, the bar of this name changes its color, like this picture

My thoughts are:

1. delete the interaction between the slicer and the bar chart

2.develop a dax formula to get only the selected value ( SelectedValue function won't work as it will get a the same name for each row)

3. this dax will generate 1 only for the selected row and 0 for other rows

4.make color code based on the rule that this function = 1 to be red

Thanks

[johndha · Accepted solution]

Thank you @amitchandak  this helped alot,

also I developed a calculation with same logic that may help anyone

color 2 = IF(HASonevalue(Names[Name])&&SELECTEDVALUE('Table'[Name]) in VALUES(Names[Name]),"Red","Blue")

[amitchandak]

@johndha , Create an independent date table with name

Names = distinct(Table[Name])

then create a color measure and use that in conditional formatting using field value option

You can use color name or hex code with prefix #

color = if(isfiltered(Names[Name])  && Max(Table[Name])  in allselected(Names[Name]) , "Red", "Blue" )

PowerBI Abstract Thesis: 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/...

[zona]

Similar problem that you've answered before.  Want selected column to be a different color.  I followed your instructions, but cannot get only one column to change color based on slicer selection. All columns turn blue or red. 
What I have:

What I want:

 Table 

DISTINCT = distinct('Example'[Letters])

Measure

Colors = IF(ISFILTERED(Example[Letters]) &&

               Max('DISTINCT'[Letters]) in

              ALLSELECTED(Example[Letters]),"Red","Blue")

Please advise what I am doing wrong. Thanks!