Forum Discussion
Solved
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 measur...
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
Thank you so much ! This solved my problem 🙂