Change percentage color to red if it's not 100% in power bi - how to?

[bbsin]

hi 

May I know how to set to change font color as long as the percentage is negative?  The formula input is not working.  

Thank you

[lbendlin · Accepted solution]

[v-zhengdxu-msft · Accepted solution]

Hi @bbsin 

First of all, Just as @lbendlin (Thanks for your contribution to the Forum) said, The 100%( = 1) but not 100(=10000%).

Then you can also realize the target with dax:

I create a set of sample data:

Then add a measure:

Color = IF(MAX('Table'[Column1])=1,"blue","red")

And right-click the field of the table visual:

Conditional formatting > Font color

Select Field value in Format style Multi-check box, then choose the color measure in the What field should we base this on?

The result is as follow:

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]