cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Changing a circles color based on statistics

Hi there, 

 

I've been trying a few things out to change the color of a circle based on a number. My code doesnt work and looks like this: 

If ( Omzet <= 3999, "#FF000", Omzet >= 4000, "#32CD32")

Omzet is the field with a number in it. Can anyone help?

 

Musky

4 REPLIES 4
Highlighted
Community Champion
Community Champion

Re: Changing a circles color based on statistics

hi

Can you just use
- Color.Red or others to replace the code?
Have a nice day.
hpkeong
Highlighted
New Member

Re: Changing a circles color based on statistics

Thanks for replying hpkeong,

I've tried this and I got this error:

 ErrorPowerApps.png

I placed this code in the "Fill" option from the circle. Is this even possible to put code in there?
Thanks in advance,

Musky

Highlighted
Community Champion
Community Champion

Re: Changing a circles color based on statistics

Hi

 

Can you look at this screenshot?

Meantime, ColorValue( "#f0f8ff" ) is the correct code (if you wish to use Hex Code)

 

try on both Color.Green & Hex Codetry on both Color.Green & Hex Code

hpkeong
Highlighted
New Member

Re: Changing a circles color based on statistics

Hey hpkeong,

 

I've got it to work right now, thanks alot for the help, it really helped. The final outcome:
If (ThisItem.Omzet <= 3999, Color.Red, Color.Green)

(**I didnt even call the "omzet" in the first code I posted here, because of the ThisItem I suppose**) Can u tell me if I'm right?

 

Musky~ 

 

Helpful resources

Announcements
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,068)