Dynamic Conditional Formatting of Clustered Bar Chart

[Anonymous]

Hello, I'm using the following methods to filter and make the bar chart a different color for one bar and neither are working. 

Method 1:

- Create the measure

BAR COLOR = IF(SELECTEDVALUE(Table[SchoolName Format])

=('Table2'[School])),1,0)

- Select bars ->fx -> rules if 1 then blue if 0 then grey

Method 2:

-Create the measure

BARColoralternate =

var _Selectedschool =  VALUES('Table'[ID])

Var _Schooltohighlight =

    SELECTEDVALUE('Table2'[ID])

Var _Filtered =

    ISCROSSFILTERED('Table'[ID])

           var _result=

    SWITCH(TRUE,not ((_Filtered)), "grey", _Schooltohighlight in _Selectedschool && _Filtered, "grey", "Blue")

    return _result

-Select bars -> fx -> Field Value ->Measure

I've scoured the internet with no solution. I put the data in a table to verify. The table shows that one value has the correct color and the other values are the default color, but it is not showing on the bar chart. Help. 

[Padycosmos]

You may try something similar to the following:

Here && is for AND and || is for OR

Colour = SWITCH(TRUE(),

CONTAINSSTRING(SELECTEDVALUE(Orders[Product Name]),"keyboard")&&

CONTAINSSTRING(SELECTEDVALUE(Orders[Product Name]),"belkin"),"Pink",

CONTAINSSTRING(SELECTEDVALUE(Orders[Product Name]),"drive")||

CONTAINSSTRING(SELECTEDVALUE(Orders[Product Name]),"trackball"),"Limegreen",

CONTAINSSTRING(SELECTEDVALUE(Orders[Product Name]),"keyboard"),"Red",

CONTAINSSTRING(SELECTEDVALUE(Orders[Product Name]),"pad"),"Yellow",

CONTAINSSTRING(SELECTEDVALUE(Orders[Product Name]),"mouse"),"Aqua",

CONTAINSSTRING(SELECTEDVALUE(Orders[Product Name]),""),"Grey")

[Anonymous]

That is hard coding the values and will not work. I'm looking for the bar chart to change 1 bar color based on the user-selected value in a slicer. For example, If the value = user selected value then blue else grey. I used this logic in the bar chart and it did not work. I don't know why.