IF statement based on percentage

[djemy1975]

Hi colleagues,

I want to write an if statement in a measure and display result in a card visual as follows:

If([Var YTD%] is greater than or equals 15% show "RCA" and format it in red font color otherwise "No RCA" and font in green color

my Var YTD% is a result of another measure: VAR YTD% = divide([VAR YTD];Budget[Bud YTD])

Any ideas are highly appreciated.

Best regards,

 

[6StringJazzer]

It's hard to give a concrete Excel answer because your question does not reference cells or data.

You need two things: A formula, and conditional formatting.

Let's say Var YTD% is in cell A1. Your formula (let's say it's in A2) will be

=IF(A1>=15%,"RCA","No RCA")

For the font color you need to use conditional formatting. Format this cell with red font. Then add this conditional formatting rule:

=A2="No RCA"

and apply green font formatting.

 

[djemy1975]

It's hard to give a concrete Excel answer because your question does not reference cells or data.

You need two things: A formula, and conditional formatting.

Let's say Var YTD% is in cell A1. Your formula (let's say it's in A2) will be

=IF(A1>=15%,"RCA","No RCA")

For the font color you need to use conditional formatting. Format this cell with red font. Then add this conditional formatting rule:

=A2="No RCA"

and apply green font formatting.

This is a Power BI question not excel .In excel the formula is so easy to apply.

Thank you for your reply even though.

Regards,

 

[6StringJazzer]

My apologies, I was looking at the Unanswered threads queue and neglected to notice it was PBI.