Highlight the data that is 30 days old from today

[Sumeesh]

Hello Everyone,

I need a solution in highlighting the data which is 30 days older than today whenever I open the dashboard in Power-BI.

Below is my data which is in excel format which is imported in power bi dashboard:-

Ticket date	Assigned by	Assigned to
Wednesday, April 15, 2020	Mr. X	Mr. A
Tuesday, March 10, 2020	Mr. Y	Mr. B
Monday, April 13, 2020	Mr. Z	Mr. C

Today's date is 22nd April 2020 and as I refresh the power-bi dashboard, the ticket date which is 30 days older should be highlighted. 

Ticket date	Assigned by	Assigned to
Wednesday, April 15, 2020	Mr. X	Mr. A
Tuesday, March 10, 2020	Mr. Y	Mr. B
Monday, April 13, 2020	Mr. Z	Mr. C

Please note today's date will be changing as per the day changes.

Let me know in case of any issue in understanding the above scenario.

Thanks and Regards,

S

[lkalawski · Accepted solution]

Hi Sumeesh,

1.  Create a measure that will check if the difference between Today () and date is greater than 30 days (if it is, assign 1):

Older than 30 days = IF( DATEDIFF(SELECTEDVALUE('Table'[Ticket date]),TODAY(), DAY) > 30,1,0)

2. Then use this measure in Conditional Formatting -> Font Color. Color for "1".

3. The result:

_______________
If I helped, please accept the solution and give kudos! 😀