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
Akash_Varuna
Super User
Super UserHi 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
Hi, thanks for this. Would this calculated measure work for different metrics, or would I need to create an individual measure for each specific metric that I want to compare against targets? Thanks
