How to - Percentage Alert

[Cornwalls]

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.....

[HotChilli · Accepted solution]

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 

https://community.powerbi.com/t5/Desktop/Conditional-Formatting-based-on-calculated-measure/td-p/640... 

[dax · Accepted solution]

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 Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HotChilli · Accepted solution]

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 

https://community.powerbi.com/t5/Desktop/Conditional-Formatting-based-on-calculated-measure/td-p/640...