Forum Discussion
Conditional Formatting Percents
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:
- When "Budget Spent (%)" is greater than or equal to 100%, highlight in Red
- 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?
You've changed the Summarization to Count which is not what you want.
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 TeamIf 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!
6 Replies
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 TeamIf 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!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 TeamIf 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!
You've changed the Summarization to Count which is not what you want.