I’m attempting to apply conditional formatting on a stacked column chart. I have Date as my X axis and Appointment count as my Y.
I’d like to highlight the appointments greater than today in a different color to show how far out the clinics are booking.
However attempts of adding a measure or supporting column have failed. Has anyone ever done something similar?
I did a video last Friday that addresses this very question. The conditional formatting portion of the video starts at about the 14:30 mark.
I hope this is helpful.
– Brian
Yes it worked perfectly! Thank you!
Great! Glad that worked well for you. It’s a pretty simple technique once you get the gist of it, but an incredibly powerful and flexible way to manipulate your visuals and conditional formatting.