Forum Discussion
Conditional formatting for values in a Matrix visual based on the date
Hello, I am currently trying to create a matrix visual where each column is a month and have the conditional formatting shade certain values in based on the month they are in. Eg. for this visual...
Hi Anonymous ,
The conditional format is applied to the values that satisfy the condition, and the corresponding column names do not apply.
M = IF(MONTH(MAX('Table'[Date]))>MONTH(TODAY()),"grey","white")
For more details, you can read below blog:
Power BI Conditional Formatting: The Ultimate How-To Guide (hevodata.com)
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.