Card Visual - Text Colour based on card content.

[StuartSmith]

Is it possible to get a "Card Visual" text colour to display red if the content contains the word "Closed".  

I have looked at conditional formatting, but that only seems to be based on numerical values and not test.   

[v-lid-msft · Accepted solution]

Hi @StuartSmith ,

We can use a color measure and condition format to meet your requirement:

1. Create a measure to show color:

FontColor = IF(CONTAINSSTRING([AddressToShowMeasure],"Closed"),"#FF0000","#000000")

Change the [AddressToShowMeasure] to the measure which you used in card visual.

2. Set the condition format for card visual:

3. Then you can make the card visualdisplay red if the content contains the word "Closed"

BTW, pbix as attached.

Best regards,

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

[Bobb]

Thank you, this helped me, too!

[JVP]

Thank you so much, been searching high and low for this. Was able to change background of my Card colour based on text value of the measure.

[StuartSmith]

That worked great and what I was trying to do, but was unsure how to do it.

[amitchandak]

Please check

https://community.powerbi.com/t5/Desktop/Conditional-Formatting-Card/td-p/113916

https://insightsquest.com/2018/05/06/conditional-formatting-for-card-visuals/