Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone please help me create a calculated column to achieve this with color.
If the end date < 5-10 weeks you milestone then "green" |
If the end date < 2-5 weeks that the milestone then "yellow" |
If the end date > that milestone then "Red" |
"
PS: Both are date columns with hierarchy.
Here's one way to do it. This measure evaluates the weeks between milestone and enddate, and returns a color value as text. You can then use that measure in conditional formatting for the background of any of your columns. Choose Field Value option and pick this measure.
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Create a column date diff
Diff = datediff([end date],[milestone],day])/7
Create a color measure
Color Date = if(FIRSTNONBLANK([Diff ],0) <5,"green",if(FIRSTNONBLANK([Diff ],0) <3,"yellow","red"))
You can use the same in Conditional formatting. After using "fields".
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
82 | |
75 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |