conditional formatting target (Soll) and actual (Ist) values

[Merkurmedium]

Hello,

I'm new to Power BI. I want to set up conditional formatting. In my table, I have target (Soll) and actual (Ist) values. If the actual values are 15% away from the target value, the actual value should be green. If the actual value is 25% away from the target value, the actual value should be yellow. Anything greater than 25% should be red. Unfortunately, I'm struggling with it. Please see the images. Thank you for the help if possible.

Thanks Uli

[amitchandak · Accepted solution]

@Merkurmedium , In case your measure is a percent column. User Number in the selection, not percent. That percent is for distribution

Power BI why Rule Based conditional formatting does not work with percent column- https://youtube.com/shorts/UaQX0yOeAWE

[Merkur]

Thanks