cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
td1979
Frequent Visitor

Piechart itemColourSet switch from SP choices column

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
td1979
Frequent Visitor

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?

View solution in original post

1 REPLY 1
td1979
Frequent Visitor

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?

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (3,010)