Piechart itemColourSet switch from SP choices column

[td1979]

Hello, 

I am having trouble correctly formatting a formula to switch the itemcolourSet on a piechart built from a choices column in a sharepoint list

List Name: Maintenance

Column Name: Status

Choices: "Not Started" / "Started" / "Closed"

I have tried all sorts in the itemcolourset formula but can not get it working - could anyone help? 

ForAll(Maintenance,
Switch(Status.Value,
"Not Started" , Red,
"Started" , CornflowerBlue,
"Closed" , LightGreen,
DimGrey
 ))

[td1979 · Accepted solution]

I resolved this by hard coding the color order (as the list items / list order will never change) - not the solution I wanted but it works. 

Still curious how this is achieved (or what my error in the  above code is) if anyone has any input?