Conditional Formatting based on Percentage Value

(0) Share

Report

Posted on by Danny_L

150

Hey all,

I have a Field that is View Percentage in an Edit Form and I wanted to have the fill color be Red if it is less than or equal to 50%, Yellow if it is between 51% and 75% and Green if it is greater than or equal to 76%.

In trying to test just the first part, the value in the field currently is 80% and I have this in the fill property:

(If(ThisItem.CurrentYieldPercentage<= Value("50%"), Red,Blue))

It changes the fill color to Red which wouldn't satisfy the formula.

This is what is in the text portion of the field:

Round(((Parent.Default - Parent.Min) / (Parent.Max - Parent.Min)) * 100, 2) & "%" (This was there when the field was added)

Anyone have any clue how to accomplish this?

Thanks!

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
@Danny_L

Change your Fill property to the following:

If(Value(Self.Text) > .75, Green, Value(Self.Text) > .5, Yellow, Red )

That should give you what you want.

I hope this is helpful for you.
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Danny_L ,

If your CurrentYieldPercentage is a number column, I think that's wise to correct your formula as:
If(ThisItem.CurrentYieldPercentage <= 0.5, Red, ThisItem.CurrentYieldPercentage > 0.5 && ThisItem.CurrentYieldPercentage <= 0.75,Yellow, Red )
The text property value doesn't affect the color property (or maybe I don't get correctly the hole imagine).

Hope it helps !
Danny_L 150 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks @RandyHayes . I think I need to put you on retainer, haha. Again appreciate it
leslie_rivera 373 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes How about based on percentage value between two numbers?
Basically, I have an app where chemists are entering numbers. I already have calculations in the background that provide a final percentage.

What I need is those percentage fields need to be color formatted:
Green for OK(the numbers are within .2 of each other) and Red for something is wrong (are not within .2)

Using the graph below. Ash 1 calculation is 13.39% and Ash 2 calculation is 13.4% .

If Ash 1 and Ash 2 are within .2 of each other the box should stay green -> if not it should turn red.

I tried using this formula in the fill value of both fields: If(Value(Ash1.Text)-(Ash2.Text)<=.2,Green,Red)
However, it sometimes works. Any ideas on how I can write this one?