Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi
I have matrix table with a reference column and a next review due date coloumn
I would like to highlight those in the current month green, next month amber and those in 2 months time red based on the date column example below
Hoping someone could suggest a dax measure I could apply for the conditional formatting many thanks
👍
Solved! Go to Solution.
Try this dax:
FORMAT = SWITCH(MONTH(SELECTEDVALUE('Table'[Review Due Date])),
MONTH(TODAY()), "Green",
MONTH(TODAY()) + 1, "Orange",
MONTH(TODAY()) + 2, "Red"
)
Hi, thank you with your help with this however we have just noticed it also highlights the months from previous years also. I.e today it formats Sept 2022, Sept 2023, Sept 2024
Is there any way to add month and year to this?
Thank you
Try this dax:
FORMAT = SWITCH(MONTH(SELECTEDVALUE('Table'[Review Due Date])),
MONTH(TODAY()), "Green",
MONTH(TODAY()) + 1, "Orange",
MONTH(TODAY()) + 2, "Red"
)
I attempted this solution, but the formatting is not working. Any suggestions?
I want anything before today's date to be red, anything this month orange, and next month, yellow.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
16 | |
8 | |
7 | |
7 | |
6 |
User | Count |
---|---|
23 | |
11 | |
10 | |
10 | |
8 |