Forum Discussion
Highlighting Older dates on Power Bi
Hello there, I'd like to highlight dates previous than the current date. For example if today is 3/3/23, then i want 1/3/23 to be highlighted in red. I've been reading other forums regarding this...
Hi peffany ,
Here are the steps you can follow：
1. Click the yellow label – Conditional formatting – Background color .
2. Enter Background color.
Format style – Field value
What field should we base this on – [Measure]
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hello,
Thank you for your quick response. What exactly is the "Measure" that we're basing it on. I added a meaure = NOW () but I cant' select it in the conditional formatting. Weird.
I'm still stuck.
