We've talked about this before. Remember the FORMAT function converts the value to text. You can try writing a formula to base the conditional formatting on that doesn't use the FORMAT function.

Mynda

Hi Mynda,

Thanks for your reply.

I was able to do conditional formatting with a measure including FORMAT function on second attachment " MeasureTextButAbleToConditionalFormatting".

So I presume, it is not only FORMAT. I just needed to know what else could it be.

On a different note, I require a different format for KPI and if I do not use Switch True and Formatting inside measure, what else can I use to have a different formatted numbers?

Thank you.

Regards,

Aye

If the FORMAT conditional formatting works it's based on text, not values. Excel also gives numbers formatted as text an order.

To answer your question, please follow the link I already provided where you can try writing a measure in which to base the conditional formatting. 

Mynda

Thanks for the link, Mynda.

I tried doing a reference measure (which is an exact same measure without formatting) and chose that for base on field. so it works now apart from having some more measures. 

But I still cannot find out the difference between the one it works and the one which was not working conditional formatting with the measure with format in it.

Regards,

Aye

Glad you got it working, Aye.

Thanks, for all the materials, Mynda. 🙂