Conditional formatting for card visualization

[Anonymous]

Hi 
I am trying to figure out a way to make the background of my card visualization more dynamic.

As can be seen here. I'm using values from column name Previous week entry status to display whether the user has submitted the form or not. If the user haven't submitted the form it will display yes with the background color of red. On the contrary, if the value is blank then the background should be green and I would like to replace "blank" with another words. Is it possible? If not can I create custom visual to make this works? thank you all of you guys in advance.

[kentyler]

Try using a measure instead of a column to provide the value for the card. Inside of a measure you can test for a blank result and substitue the text you want instead of blank.  If the column is not blank, then just have the measure return the value from the column.

[Anonymous]

Could you give me some example of the measure idea. Should I use "If" or something else?

[kentyler · Accepted solution]

Card Message =
VAR card_value = SELECTEDVALUE('my table'[my column])
RETURN IF(ISBLANK(card_value),"No Value",card_value )