web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Using collection with ...

Power Apps

Suggested Answer

Using collection with colours field in chart itemColorSet

(0) Share

Report

Report

Posted on by romankorchak1

47

Hi All

I got a collection with one field of different colours .

This collection is used to create a Column Chart and I want columns in a chart to have a specific colour depending on a current value.

So I have a collection

{V:34, c:RGBA(255, 204, 153, 1)}
{V:50, c:RGBA(255, 204, 204, 1)}

{V:64, c:RGBA(204, 255, 204, 1)}

And I want chart columns to have those colours is per "c" field in collection

I know itemColorSet property of the chart takes a table, but I just couldnt figure out how to convert collection into a table.

I tried
Set(ColTable, Table(Collect.c))

but it gives me table of 10 digits numbers instead of colours :/

Any ideas?

Thanks

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Nandit 1,568 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi

Are you using the Column Chart to display a singe value / single column in the visual?

If yes, then you can use the following to achieve that directly in the iconColorSet:

Switch( currentValue, 34, [ RGBA( 255, 204, 153, 1 ) ], 51, [ RGBA( 255, 204, 204, 1 ) ], 64, [ RGBA( 204, 255, 204, 1 ) ] )

If you are trying to change color for multiple columns in the column chart using Value, I don't think that's achievable.

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
Nandit 1,568 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Following up to check if you were able to solve this issue using my suggestion?

Kind regards,
Nandit

Was this reply helpful? Yes No

Join the conversation