Display different colors according to character content

[Leah0528]

On the Table Visualization, I want that when the content in the column is 'Fail', the characters displayed in red, and when it is 'Pass', it should be displayed in green.

I tried Conditional Formatting, but it required inputting the count of value rather than the content, and it can not be changed.

Please provide any other way to achieve this effect, thanks!

[JorgePinho]

Hello @Leah0528 !

You can create a measure like this:

Color = SWITCH(TRUE(),
SELECTEDVALUE(table[column]) = "Pass", "Green",
SELECTEDVALUE(table[column]) = "Fail", "Red",
"Black")

Then apply conditional formatting on the column and choose Field Value instead of Gradient. Use the measure I suggested you and it must work 🙂

[Leah0528]

Thanks for your solution, but...

I add the new measure but when I choose Field Value, it did not work...

Could you please let me know which step is wrong?

I'm new in Power BI😢, so please provide detailed steps, thanks

[JorgePinho · Accepted solution]

Hello @Leah0528 !

On Field Value on the box "What field should we base this on?" please select the measure.