Measure to Change Marker Color

[AllanBerces]

Hi good day,

Pls can anyone help me to create the measure on how can i change the color of my marker. I have table below, what i want is turn the marker in to RED if the date already due and the Remarks is blank, turn GREEN if due or in coming if the remarks started.

Thank you

[bhanu_gautam]

@AllanBerces , You can create a measure 

MarkerColor =

   IF(

       ISBLANK([Remarks]) && [DueDate] < TODAY(),

       "Red",

       IF(

           NOT(ISBLANK([Remarks])) && [DueDate] >= TODAY(),

           "Green",

           "DefaultColor"

       )

   )

Add this measure to visual and setup conditional formatting

[AllanBerces]

Hi @bhanu_gautam by the wat Remarks and Date are in column.

Thank you

[bhanu_gautam · Accepted solution]

Instead of measure try creating calculated column

MarkerColor =

   IF(

       ISBLANK([Remarks]) && [DueDate] < TODAY(),

       "Red",

       IF(

           NOT(ISBLANK([Remarks])),

           "Green",

           "DefaultColor"  // You can set a default color if needed

       )

   )

[AllanBerces]

HI @bhanu_gautam thank you for your reply, but the one you sent not working, the error show

"the value for "Remarks" cannot be detirmined. 

Thank you