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
           )
       )
bhanu_gautam's avatar
bhanu_gautam
Super User
2 years ago

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

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