Forum Discussion

StuartSmith's avatar
StuartSmith
Power Participant
6 years ago
Solved

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...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    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.

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

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's avatar
Bobb
Frequent Visitor
1 year ago

Thank you, this helped me, too!