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

I have the same question (0)

All responses (4)

Answers (1)

jatcube 508 on at

Like (0)

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

Was this reply helpful? Yes No
DanNZ1 6 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

jatcube 508 on at

Like (0)

Report
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.

Was this reply helpful? Yes No
DanNZ1 6 on at

Like (0)

Report

Thank you! That worked!

Was this reply helpful? Yes No