Forum Discussion
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...
Hi v-janeyg-msft ,
Thank you for your response. I applied the countx function to the measure as you've shown, but the result in my visual is that if any record is late, all dates show red.
When I filter the late record out with a slicer, they all go blue.
I am needing the colors to not be uniform, but indicate per date if there was a late record on that date. The result would be some dates as blue and some dates as red. Let me know if you have any further thoughts.
Thank you!
Hi, Anonymous
I am not clear what visual you are using and in which option the conditional formatting is used. Can you explain it?
It's fine with me.
Can you share a sample file? So we can see your problem intuitively.
Best Regards,
Community Support Team _ Janey