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 topic but they dont seem to do me justice.
When I'm on the "Conditional Formatting" tab, its based on the count of dates and not the dates themselves meaning that if it sees that a date is used more than once in my table, its highlighted which is not what i want.
Any help ASAP would be greatly appreciated. Thanks in advance.
3 Replies
- amitchandak
Super User
peffany , You can use measure based conditional formatting using field value option
Color Field - Color Measure - Conditional formatting
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://www.youtube.com/watch?v=RqBb5eBf_I4 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.
