In Power BI, use Conditional Formatting to color expired dates:
- Select the column with dates.
- Go to Format pane > Conditional Formatting.
- Choose Background color or Font color.
- Use Rules: If
[Date] < TODAY(), set a color (e.g., red for expired). - Apply changes.
Or create Column using Modeling : Expired Flag = IF(‘Table'[Date] < TODAY(), “Expired”, “Active”)
Sample Dataset to use: https://colorstech.net/wp-content/uploads/2025/02/expireddates.xlsx
| Date | Order Quantity |
|---|
| 2025-02-15 | 10 |
| 2025-02-14 | 12 |
| 2025-02-13 | 8 |
| 2025-02-12 | 15 |
| 2025-02-11 | 9 |
| 2025-02-10 | 11 |
| 2025-02-09 | 7 |
| 2025-02-08 | 14 |
| 2025-02-07 | 10 |
| 2025-02-06 | 6 |
| 2025-02-05 | 8 |
| 2025-02-04 | 9 |
| 2025-02-03 | 12 |
| 2025-02-02 | 15 |
| 2025-02-01 | 7 |
| 2025-01-31 | 11 |
| 2025-01-30 | 10 |
| 2025-01-29 | 13 |
| 2025-01-28 | 14 |
| 2025-01-27 | 9 |