Piechart itemColourSet switch from SP choices column

(0) Share

Report

Posted on by td1979

157

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
 ))

Categories:

I have the same question (0)

All responses (1)

Answers (1)