Text Color Expression for Performance

[Zaky]

Hi,

I have created the table below. Let say i want to show the Performance (%) table for result below 100% it would be change in Red color. In this case i want performance % with 99.51% in red. How can i do it?

Current measure that i used is:

Performance percentage = ('Incident Raw Data (SLA Resoluti'[Resolution Met]/[Resolution Total])

Appreciate if someone can help me on this.

Thanks.

[v-danhe-msft]

Hi @Zaky ,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

Regards,

Daniel He

[MFelix]

Hi @Zaky,

You need to use the conditional formatting on the Performance (%).

Select the Perfromance % column on your table and choose the conditional formatting, font color then using the rules set the treshhold for the color red.

As you can see all that is below 100% is in colour red, this can be set for any set of different rules check the documentation and see the rest of the potential on this.

Regards,

MFelix

[Zaky]

Hi,

The solution is working fine for the performance table. To add, how can this can be applied to the chart as well?

[v-danhe-msft · Accepted solution]

Hi @Zaky,

Could you have tried the "Advanced Controls" in the format of the color:

It could also set the conditional formatting:

Regards,

Daniel He