Forum Discussion
Solved
Conditional Formatting Based on Measure
I have a column(Act/TGT) that divides current revenue with its target to get a percentage. I want to apply conditional formatting to highlight values that are below the elapsed shipment days. ...
For this I would use some variation of the following and select this measure using a Field Value in the conditional formatting options.
ColorDays = IF ( [ActTGT%] > SELECTEDVALUE ( ShippingTargets[Target] ), "#1b7640", "#ff0000" )The selected value function allows this to be dynamic by referencing a small table of shipping targets you would need to build. If you just want the color to change at a certain static number, you could remove that piece.
If I use the rule category, there doesnt seem to be a way to have max to change based on number of elapsed days.
I need the range to be from 0 to (number of elapsed day/total number of shipment days)
There isnt an area to add in a field.
For this I would use some variation of the following and select this measure using a Field Value in the conditional formatting options.
ColorDays = IF ( [ActTGT%] > SELECTEDVALUE ( ShippingTargets[Target] ), "#1b7640", "#ff0000" )
The selected value function allows this to be dynamic by referencing a small table of shipping targets you would need to build. If you just want the color to change at a certain static number, you could remove that piece.