Hierarchy Slicer different colors for different rows based on a static value

[kdixon5490]

Currently I'm using the slicer and have added 3 columns

Seat Status                               Count of Seat Status                           Percentage of Seat Status

I want to know if there is away for me to change the background color of the Count of Seat Status based on the Value in Seat Status.

So if Seat Status value = Sold then Change background of Count to Green, but if the Seat Status value = Open then show Count to be Blue.

Any help would be appreciated.

[amitchandak]

@kdixon5490 ,I doubt their conditional formatting option in the slicer

you can create a color measure and use that in conditional formatting with "Field value" option

Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
Color Year = if(FIRSTNONBLANK(Table[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK(Table[Year],2014)>2018,"red","yellow"))

Color  = if(FIRSTNONBLANK(Table[Year],2014) <=2016 && AVERAGE(Sales[Sales Amount])<170 
,"lightgreen",if(FIRSTNONBLANK(Table[Year],2014)>2018,"red","yellow"))
Color sales = if([Sales Today] -[sales yesterday]>0,"green","red")

color =
switch ( true(),
FIRSTNONBLANK(Table[commodity],"NA") ="commodity1" && sum(Table[Value]) >500,"lightgreen",
FIRSTNONBLANK(Table[commodity],"NA") ="commodity2" && sum(Table[Value]) >1000,"lightgreen",
/// Add more conditions
"red"
)

refer steps

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values