Unanswered

Pie chart colour conditions

(0) Share

Report

Posted on by DJIX12

Hi all,

Can't figure out how to get the conditions of the colours of my chart to correspond to the true false value... For context, the chart is getting data from a collection and I think the first data dictates whether true or false will be red and the other would be green.

Is there a - If true = green, if false = red condition?

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (0)

Geeks_D 1,169 on at

Like (0)

Report

To manage colors for chart
You fix that in the side bar

The Item color set is hierarchical the first item in your collection takes the first RGBA from the item color set .. second item in your collection takes second just like that
You can also put in your if statement here

Was this reply helpful? Yes No
DJIX12 63 on at

Like (0)

Report

What would the syntax look like if I wanted True = Green, False = Red?

Was this reply helpful? Yes No
BCBuizer 22,510 Super User 2025 Season 2 on at

Like (0)

Report

Hi @DJIX12 ,

Colors in the pie chart are assigned in order at which they are in the ItemColorSet property of the PieChart control.

For instance, with the ItemColorSet property set to [Color.Green, Color.Red]

When setting the Items property to first show the True percentage ( [{Label: "True", Percentage: 70}, {Label: "False", Percentage: 30}] ), this is what the chart looks like:

However, if you first offer the false percentage ( [{Label: "False", Percentage: 30}, {Label: "True", Percentage: 70}] ), the colours are reversed:

So if you want a certain label to match with a certain colour, match the position in the tables for the Items and ItemColorSet.

Was this reply helpful? Yes No
Geeks_D 1,169 on at

Like (0)

Report

@BCBuizer analysis solves it
If the first in your chart collection is true , the Item color Set first color should be green
Then the second Item is False, the Color set item should be red

Was this reply helpful? Yes No
DJIX12 63 on at

Like (0)

Report

Issue is the first item is dynamically changing month over month. So I require a workaround

Was this reply helpful? Yes No
Geeks_D 1,169 on at

Like (0)

Report

You might need to adjust your collection to have a threshold to keep some items true and other false

Was this reply helpful? Yes No
DJIX12 63 on at

Like (0)

Report

Is there a way to sort the data so it's true first and false following? This is my syntax

AddColumns(
GroupBy(Filter(Source, 'Transaction'.Value = "ABC123"), "FirstTimeRight_x003f_","GroupData"),
"Percentage",
CountRows(GroupData)/CountRows(Filter(Source, 'Transaction'.Value = "ABC123"))
)

Was this reply helpful? Yes No
BCBuizer 22,510 Super User 2025 Season 2 on at

Like (1)

Report
Hi @DJIX12 ,

May I ask what the Items property of your Piechart looks like?

In case you are using a collection, you could use something like the below for the ItemColorSet:

ForAll( colPiechart, Switch( ThisRecord.Label, "True", Color.Green, "False", Color.Red ) )

FYI this is what the collection looks like:

ClearCollect( colPiechart, [{Label: "False", Percentage: 30}, {Label: "True", Percentage: 70}] )

and this is the result:

Was this reply helpful? Yes No
DJIX12 63 on at

Like (0)

Report

It is a collection and this is the items property for my pie chart

AddColumns(
GroupBy(Filter(Source, 'Transaction'.Value = "ABC123"), "FirstTimeRight_x003f_","GroupData"),
"Percentage",
CountRows(GroupData)/CountRows(Filter(Source, 'Transaction'.Value = "ABC123"))
)

Was this reply helpful? Yes No
BCBuizer 22,510 Super User 2025 Season 2 on at

Like (0)

Report

Hi @DJIX12 ,

What you can do is to insert a hidden gallery and set its' Items property to what you currently have as the Items property of the Piechart. Like this it can be referenced from both the Items and ItemColorSet properties of the PieChart:

In the above I left galHidden visible to show what I mean, but its' Visible property should be set to false.

Was this reply helpful? Yes No