Unanswered

Pie chart color not showing for choice column

(0) Share

Report

Posted on by Nikhil2

522

I have pie chart which does not show the color properly where it uses choices column. It shows different than the one which is below.

ForAll(AddColumns(GroupBy(Task,Task.value, "Label"),"Count", CountRows(Label)),
 Switch(
 Task.value,
 "At Risk", Color.Yellow,
 "Complete", Color.DarkBlue,
 "On Track", Color.Green,
 "Not On Track",Color.Red,
 "Not Yet Started",Color.Gray
 )
)

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

developerAJ 4,763 on at

Like
a
(0)

Report
Copy link

Link copied!
@Nikhil2

Try this out
SortByColumns( AddColumns(GroupBy(AddColumns( Task,"TaskValue",Task.value),"TaskValue", "Label"),"Count", CountRows(Label)),"TaskValue",SortOrder.Descending) use this as items property of pie chart
color set:[Color.Yellow,Color.DarkBlue, Color.Green,Color.Red,Color.Gray]

Please click Accept as solution and Thumbs Up. if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
You can connect with me on LinkedIn
Nikhil2 522 on at

Like
a
(0)

Report
Copy link

Link copied!
@developerAJ For the items property of the pie chart is working fine, but I want to make itemcolor set . I want make them switch dynamically.
ForAll(AddColumns(GroupBy(Task,Task.value, "Label"),"Count", CountRows(Label)), Switch( Task.value, "At Risk", Color.Yellow, "Complete", Color.DarkBlue, "On Track", Color.Green, "Not On Track",Color.Red, "Not Yet Started",Color.Gray ) )
developerAJ 4,763 on at

Like
a
(0)

Report
Copy link

Link copied!

try the code i gave below
check the output it will be same as you want