Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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 🙂
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
User | Count |
---|---|
98 | |
89 | |
82 | |
70 | |
67 |
User | Count |
---|---|
114 | |
104 | |
101 | |
72 | |
65 |