Forum Discussion
dirkkoch
Helper III
Helper IIIConditional formatting with measure for font color (date column value blank and not blank)
Hi, I have a calculated date column (column name: hexcode) and I want to create a measure which sets the hex code to a data card visual to font color white (#ffffff) if it is blank and to font c...
Hi,
What I would do is to create a calculated column that return the colour:
Date Formatted = IF(Date_Table[Date]=BLANK(),"#ffffff", "#f8f32b")Then in the "Callout Value section" of your Card you can set to change the colour based on the Calculated column you have created:
Uspace87
Resolver III
Resolver IIIHi,
What I would do is to create a calculated column that return the colour:
Date Formatted = IF(Date_Table[Date]=BLANK(),"#ffffff", "#f8f32b")
Then in the "Callout Value section" of your Card you can set to change the colour based on the Calculated column you have created: