Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to Solution.
Hi @donesbi ,
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 Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @donesbi ,
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 Kong
If 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-...
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/1447...
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
95 | |
86 | |
78 | |
66 |
User | Count |
---|---|
151 | |
121 | |
111 | |
107 | |
95 |