Forum Discussion

frknklcsln's avatar
frknklcsln
Icon for Helper II rankHelper II
3 years ago

how to apply conditional formatting for text values in a table

Hi,   I have a table like below:     I would like to color format the blank values as red. I know how to do this with numeric values but I couldn't find for the text datatype columns.   ...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
3 years ago
Hi,
Try using this DAX  for blanks.

Title =
VAR Name1 = IF(SELECTEDVALUE('Sheet1'[Column]) = Blank(), True, False)
RETURN
SWITCH(
TRUE(),
Name1 , "#CD5C5C")
 
Thanks.
frknklcsln's avatar
frknklcsln
Icon for Helper II rankHelper II
3 years ago

Hi Anonymous , thanks for the response.

 

Is this a measure or a calculated column?

  • frknklcsln's avatar
    frknklcsln
    Icon for Helper II rankHelper II
    3 years ago

    Anonymous , second question,

     

    how can I apply this after the dax? can you show me in screenshots?

     

    much appreciated

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi frknklcsln it is a measure