Forum Discussion
Card Visual - Text Colour based on card content.
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.
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.
5 Replies
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.That worked great and what I was trying to do, but was unsure how to do it.
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.
Thank you, this helped me, too!
