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 dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
25 | |
12 | |
8 | |
7 | |
7 |
User | Count |
---|---|
27 | |
12 | |
11 | |
10 | |
6 |