Forum Discussion
Power BI Conditional formatting format only one row based on row category
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
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
3 Replies
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
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.
Thank you so much ! This solved my problem 🙂
