Forum Discussion
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 compared to other date fields, then blue color
3) If the date is in the future, but it is NOT the closese to today compared to other date fields, then yellow color
Hi,
PBI file attached.
Hope this helps.
6 Replies
jxkang Is that what your source data looks like or ?
Hi Greg,
Yes, the dates are in different columnsHi,
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
Hi jxkang ,
Thank you for reaching out to Microsoft Fabric Community.
Thank you Ashish_Mathur, Greg_Deckler and srlabhe for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.
Thanks and regards,
Anjan Kumar Chippa
