Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
2 years ago
Solved

Measure to Change Marker Color

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 Rem...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    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's avatar
AllanBerces
Post Prodigy
2 years ago

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

 

Thank you

bhanu_gautam's avatar
bhanu_gautam
Super User
2 years ago

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
       )
   )