Forum Discussion
How to - Percentage Alert
Hi Everyone,
First time posting so go easy on me.
I am looking for a way to achieve the below result that Columns A+B+C+D=E
But if Column E is greater than 80% of Column F, it will be formatted Red.
| Stored Red Apples | Stored Blue Apples | Shipped Red Apples | Shipped Blue Apples | Total Apples | Limit |
| 1 | 1 | 1 | 4 | 7 | 10 |
| 1 | 1 | 1 | 5 | 8 | 10 |
Hope this makes sense.....
Welcome.
Should really be in Desktop forum. (just advice)
You'll need to add the values of course (can do this in Power Query or DAX).
You need a column or measure to work out the percentage, then apply conditional formatting on the ApplesTotal value.
A couple of links:
https://radacad.com/show-me-the-biggest-number-conditional-formatting-in-power-bi
Hi Cornwalls ,
As HotChilli mentioned, you could try to use column or measure and set conditional formmating on it to achieve this goal.
You could refer to my sample for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Welcome.
Should really be in Desktop forum. (just advice)
You'll need to add the values of course (can do this in Power Query or DAX).
You need a column or measure to work out the percentage, then apply conditional formatting on the ApplesTotal value.
A couple of links:
https://radacad.com/show-me-the-biggest-number-conditional-formatting-in-power-bi
Hi Cornwalls ,
As HotChilli mentioned, you could try to use column or measure and set conditional formmating on it to achieve this goal.
You could refer to my sample for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.