Conditional Formatting

[Mo_15797]

Hi, I have a column called Status which shows the status for each row, filled with either a G, C, IP etc: see below all the RAG's I have. 

The conditional formatting on the report builder only works for G and R. I have also tried creating a new column with switch and IF functions to replace the alphabetical values with numerical which resulted in only G and R being converted to numbers. I also tried to create a conditional column in power query to achieve the switch to numbers, but get the same thing; only G and R get populated and I get a "Null" for all the others.

G (Green)

IP (In-Progress)

OH (On-Hold)

R (Red)

NS (Not-Started)

C (Complete)

Any advise on how to fix this?

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Mo_15797]

Here you go

Summary Status​	Status
SUMMARY 1	G
SUMMARY 2	IP​
SUMMARY 3	IP​
SUMMARY 4	C​
SUMMARY 5	R
SUMMARY 6	A
SUMMARY 7	G
SUMMARY 8	IP​
SUMMARY 9	IP​
SUMMARY 10	C​
SUMMARY 11	OH
SUMMARY 12	G
SUMMARY 13	IP​
SUMMARY 14	IP​
SUMMARY 15	G
SUMMARY 16	G
SUMMARY 17	NS​
SUMMARY 18	NS​
SUMMARY 19	C​
SUMMARY 20	OH