KPI chart to display a RAG status based on performance

[MB2024]

Hello all

I have a KPI Chart that uses a master measure to display a RAG status.  I have the following IF statement

if(rag_status>=6,'Red',if(rag_status<=3,'green','Amber')) 

What I would like to do is have the RAG status in the relevant colour.  For example if the KPI is displaying Red I want the text to be red. 

Any help appreciated 

[Lisa_P]

In the Master Measure for RAG status, edit and go to the Segment colors tab.

Set to Custom coloring, and select the fixed value segments and decide where your segments are and assign the colors on the tab.

[MB2024]

Thanks i am guessing i will have to have a dual output for my if statements?  As the  limits are in percentages but my if statement is currently text. 

sorry for the newbie questions still learning

[Lisa_P]

You are only coloring using the values, you should be using the dimension values for the labels. To apply this color scheme use the color by measure with library colors turned on.