Forum Discussion
Power BI Conditional Formatting based on date
Hi everyone
Hoping to get some help with conditional formatting. I have a Table with 12 columns for different milestone dates. I would like to conditionally format these to show a yellow background when the upcoming milestone date is within the next 3 months. This sort of conditional formatting is quite simple in Excel so I'm thinking i must be missing something here as I can't seem to find an option for conditionally formatting based on dates.
Thank you
Hi Anonymous ,
You can create a calculated column and then use this calculated column as the conditional format for the date field based on it.
Column = DATEDIFF(TODAY(),test[MilestoneDate],DAY)Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Anonymous ,
You can create a calculated column and then use this calculated column as the conditional format for the date field based on it.
Column = DATEDIFF(TODAY(),test[MilestoneDate],DAY)Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
