Hi Aye,

When you use the FORMAT function you're converting the measure result to text. Conditional Formatting can't apply formats based on numeric rules because they're text. You should use the formatting on the Measure Tools tab rather than the FORMAT function.

Yes, you can use IF. In the Contoso Power BI file I built in the course there is a measure called Act. Vs Bud. that uses IF.

Mynda

P.S. Please don't put percentage signs in file names as I can't open them because this character has a different meaning when used in a URL. As a general rule, you should never use special characters in any file names 😉

Many thanks, Mynda.

I will avoid using characters in the file name. Thanks for the note.

regards,

Aye