Answered

Pie Chart Items color set is not working

(0) Share

Report

Posted on by Nikhil2

522

I am trying to change the color based on the status column, when I change the status the color shows the same as first color.

ForAll(
 data source,
 Switch(
 Status,
 "At Risk",Yellow,"On Track",Green,"Not Yet Started",Gray,"Complete",DarkBlue,"Not On Track",Red))

I have 6 items in the gallery when I change the item from "Not Yet Started" to "On Track". "Not Yet Started" in Pie Chart shows the Red color instead of Gray and another status "Not on Track" to Green. I am not sure what is wrong with the color set

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

WiZey 3,023 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @Nikhil2 ,

Can you try the code below ?

ForAll( data source, { Value: Switch( Status, "At Risk",Yellow,"On Track",Green,"Not Yet Started",Gray,"Complete",DarkBlue,"Not On Track",Red) } )

Was this reply helpful? Yes No
Nikhil2 522 on at

Like
a
(0)

Report
Copy link

Link copied!

@WiZey I tried the above code but as I have explained in the main question it showing like this. On Track should be Green but it is showing gray as gray should be Not yet started

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Nikhil2 ,

I'm experimenting on my side to try and replicate your case.

For now, could you tell me if changing "On Track"'s color has any impact on the graph? Changing "Not Yet Started" has any impact too? Is there perhaps a hidden space character in the "On Track" of your datasource? Is the datasource in the formulae the same as the one your provided the graph?

Was this reply helpful? Yes No
Nikhil2 522 on at

Like
a
(0)

Report
Copy link

Link copied!

@WiZey Yes there is a impact on changing the On Track color and Not Yet Started Color. Yes, formulae and graph are same.

Was this reply helpful? Yes No
Verified answer

WiZey 3,023 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Unless I intentionally gives different datasource, I can't seem to replicate your issue. I'm kind of running out of ideas, sorry.

According to many other topics, the formulae seems to be correct. The issue may be on the Power Apps side.

My last suggestions are deleting the pie chart and recreating it from scratch. I sometimes notice some internal failures with my components and simply deleting and re-creating them seems to fix it.

Was this reply helpful? Yes No
Nikhil2 522 on at

Like
a
(0)

Report
Copy link

Link copied!

I guess it could be powerapp issue, deleting the pie chart and adding it back solved the issue.

Was this reply helpful? Yes No
Nikhil2 522 on at

Like
a
(0)

Report
Copy link

Link copied!
Just updated the formulae as well.

ForAll(AddColumns(GroupBy(data source,"Status","LabelRisk"),"Count12", CountRows(LabelRisk)), Switch( Status, "At Risk", Yellow, "Complete", DarkBlue, "On Track", Green, "Not On Track",Red, "Not Yet Started",Gray ) )

Was this reply helpful? Yes No