Forum Discussion
Solved
Power BI Table Conditional Formatting
Not sure if this is possible: I am trying to highlight cells in a table where 1) If the date is in the past, then green color 2) If the date is in the future, but it is the closest to today co...
Hi,
PBI file attached.
Hope this helps.
Create a measure
DateFlag=if (Date1<today() then 1,
if(Date2=today() then 2, 0)
use this measure for conditional formatting
not sure the criteria for Date closer so accordingly change the same