Forum Discussion
Solved
Conditional Formatting Rules
I've created a series of rules to enable a RAG traffic system to track performance against targets. The tolerance is set at 10%, with the folllowing conditions: Green: Actual meets or exceeds the t...
Hi eladumitrascu Try this please
Create a calculated Column or Measure
Formula :RAGStatus = IF( [Actual] >= [Target], "Green", IF( [Actual] >= [Target] * 0.9, "Amber", "Red" ) )- In the visual, add the RAGStatus column or measure.
- Apply Conditional Formatting:
- Go to the "Values" area of the visual.
- Select Conditional Formatting → Background Color or Font Color.
- Use rules based on the RAGStatus column:
- Green → Hex (#00FF00)
- Amber → Hex (#FFC000)
- Red → Hex (#FF0000)
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
shafiz_p
Super User
Super UserHi eladumitrascu Try this:
RAG Status =
VAR Target = [Target]
VAR Actual = [Actual]
VAR Tolerance = 0.1 * Target
RETURN
SWITCH(
TRUE(),
Actual >= Target, "Green",
Actual >= Target - Tolerance, "Amber",
"Red"
)
Hope this helps!!
If this solved your problem, please accept it as a solution and a kudos!!
Best Regards,
Shahariar Hafiz