Conditional formatting with measure for font color (date column value blank and not blank)

[dirkkoch]

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 color yellow (#f8f32b) it there is a date shown in the column. 

So far I tried to following measure but it does not return a white font color, although the date column is empty/blank:

calculate(if(sum('table1'[hexcode].[Date])=BLANK(),"#ffffff", "#f8f32b"))

I would be thankful for any support!

[Uspace87 · Accepted solution]

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 · Accepted solution]

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:

[dirkkoch · Accepted solution]

@Uspace87  That seems to do the job. Thanks!