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 Remarks is blank, turn GREEN if due or in coming if the remarks started.

 

 

Thank you

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

4 Replies

  • 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

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