Answered

Sorting a column chart with custom colors

(0) Share

Report

Posted on by DanNZ1

Hi,

I have an app that I've set up for the Steptember challenge at work. Everything works fine except for the column chart that I'm using to display total steps throughout the month. I have this sorted by first name ascending...

Items:

SortByColumns(Steptember,"FirstName",Ascending)

What I want to do is display the person's team color for their bar on the graph.

The below works fine provided I don't sort the data as above...

ItemColorSet:

ForAll(
Steptember,
Switch(
Team.Value,
"Tahi", RGBA(255, 156, 58, 1),
"Rua",RGBA(189, 55, 128, 1),
"Toru", RGBA(6, 181, 255, 1),
"Whā",RGBA(108, 164, 99, 1),
Color.Gray))

With the sort by first name in place the colors no longer correspond to the correct person...

How do I incorporate the requirement to sort by first name into ItemColorSet?

Thanks in advance for any assistance offered.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

jatcube 508 on at

Like
a
(0)

Report
Copy link

Link copied!
@DanNZ1 can you try adding the ThisRecord property as such?
ForAll( Steptember, Switch( ThisRecord.Team.Value, "Tahi", RGBA(255, 156, 58, 1), "Rua",RGBA(189, 55, 128, 1), "Toru", RGBA(6, 181, 255, 1), "Whā",RGBA(108, 164, 99, 1), Color.Gray))
DanNZ1 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks. Just tried that and it didn't make any difference unfortunately.
Verified answer

jatcube 508 on at

Like
a
(0)

Report
Copy link

Link copied!
Oh I see @DanNZ1, I didn't notice, try this
ForAll( SortByColumns(Steptember,"FirstName",Ascending), Switch( ThisRecord.Team.Value, "Tahi", RGBA(255, 156, 58, 1), "Rua",RGBA(189, 55, 128, 1), "Toru", RGBA(6, 181, 255, 1), "Whā",RGBA(108, 164, 99, 1), Color.Gray))
This should work since the order of the rows needs to match in items and the ItemColorSet as well for colors to be added properly.

Alternatively, you could just do a ClearCollect with the sorting in place and simply reference the sorted collection in both places. hope this helps.
DanNZ1 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you! That worked!