Forum Discussion
Advocate IConditional Formatting Based on Measure
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.
Solution Sagebecause, you are using Format by 'Color scale' and then keeping same color for Minimum and Maximum. This will make same red color for all the values, if you use two different color for Min and Max, then it will format a color gradient for all the values.
Perhaps, in the format by, you should use 'Rules' category if you just want one kind of color for values matching the conditions and no format/different format for not matching the condition.
AuburnEagle2315If 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.