Multiple Conditional Formatting with diff Data Formats

Hi, NilR ;

I found the type of Financial Variance is text because here use FORMAT().

so if coniditonal format is rules, may be cause error. I think you could create other measure as Color based on a calculation.

Such as:

Measure = IF(CONTAINSSTRING([Financial Variance],"%"),"Green",IF([Financial Variance]=0,"Black","Red"))

The final output is shown below:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.