News and Announcements icon

Power Platform CommunityForums Power Apps Pro Dev & ISV Using collection with ...

Power Apps Pro Dev & ISV

Unanswered

Using collection with colours field in chart itemColorSet

(0) Share

Report

Report

Posted on by romankorchak1

40

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 Platform Build Tools

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Nandit 1,091 on at

Like (0)

Report
Using collection with colours field in chart itemColorSet

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!

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 142,008

#2

RandyHayes 76,308

#3

Pstork1 63,531

Leaderboard

Featured topics

Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)

Product updates

Microsoft Power Platform Community release plans