Conditional Formatting Percents

[Anonymous]

I'm trying to create two rules for one column in a table and can't figure out how to get them both functional.

What I would like to see: 

1.  When "Budget Spent (%)" is greater than or equal to 100%, highlight in Red
2.  When "Budget Spent (%)" is equal to 85% or between 85% and 100%, highlight the cell in Yellow

I was able to get #1 working using a suggestion from the forum (but the logic seems weird to me). I can't figure out why #2 is behaving like #1 as seen below.  (For the 11 rows seen in this photo, I want the first 3 to be blank, the next 6 to be red, and the last 2 to be yellow). Can anyone help me?

[HotChilli · Accepted solution]

You've changed the Summarization to Count which is not what you want.

[HotChilli · Accepted solution]

You've changed the Summarization to Count which is not what you want.

[Anonymous]

Hi @Anonymous ,

Thanks for the reply from HotChilli .

This is sample data I created.

Type	Value
A	49.00%
B	49.00%
C	49.00%
D	105.00%
E	105.00%
F	105.00%
G	105.00%
H	105.00%
I	105.00%
J	97.00%
K	97.00%

Set up the conditional formatting as shown in the following image.

The final page effect is as follows:

The pbix file is attached.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Anonymous]

Hi Yang!

Thank you for your quick reply! Unfortunately, this did not solve my problem. When I implemented your solution, this is the result I got (they all turned red). Thoughts?

[Anonymous · Accepted solution]

Hi @Anonymous ,

I agree with @HotChilli , your Summarization is not correct, please check our differences.

If you have any other questions, please feel free to contact me.

If it still does not solve your problem, please provide me with the pbix file, be careful to remove sensitive information, and do not log in to your account in Power BI Desktop when uploading the pbix file.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[HotChilli]

Try this:

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#color... 

[Anonymous]

Hi HotChilli!

Thank you for your quick reply. Unfortuately, this did not solve my problem. When I implemented your suggested solution, they all turned red. Thoughts?