Power BI Conditional formatting format only one row based on row category

[nehapowerbi]

HI, 

I am trying to create a simple Employee table where I have yearly counts for male and female for last few years . I have created a measure to show percentages of male female by year as a measure . I am looking to format percentages as :

30%  and below as red

31 % and above as Green  

The problem is I want to achieve this conditional formating logic but want to apply it to  female rows only  (eg : based on the rule %2023parentrow column  I want only 42% to show as green (since its greater than 30% ) and not 58% male as green).  See attached table 

[nehapowerbi]

 Thank you so much ! This solved my problem 🙂

[jdbuchanan71 · Accepted solution]

@nehapowerbi 

You can write a measure to read the gender and return a formatting color for only F.

Format Female = 
VAR _Gender = SELECTEDVALUE ( Table[Gender] ) = "F"
RETURN
IF ( _Gender, IF ( [Gender%] > .3, "Green", "Red" ) )

Formate the measure as text then apply it as conditional formatting to the % measure.

My sample data has Female/Male rather than F/M

[we-out-here]

Excellent solution. Am I to understand that Power BI thus automatically interprets the strings "Red" and "Green" into their appropriate colors? Is there a list of what colors with which this can be done? Or any other similar tricks?

I hope it's appropriate to ask here.