Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Create Measure for Conditional Formatting Categorical values

Hi there,    I have a categorical column with three values: On Time, Late, or Blank. I am trying to apply condition formatting to the x-axis (date) for a chart. I need a measure to return red if va...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Create a color measure and use that in conditional formating using field value option

 

Ontime_Number =
VAR OnTime = max(FlaggingLabor[On Time])
RETURN

SWITCH(TRUE(),
OnTime = "On Time", "Blue",
OnTime = "Late", "Red",
ISBLANK(OnTime),"Green"
)

 

How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi amitchandak ,

     

    Thanks for your response. When I implement your suggestion, all of the dates on the x-axis still show as one color or "On Time". I think what is happening, is that on some dates have multiple values for the field On Time. In this case, I would want to have the date show red if any record is late on that date. Is this possible? 

     

    Thanks