Report to color code changes based on a main worksheet

[jay7519]

Hi,

I need to maintain 2 worksheets. One as main reference and another to be refreshed on a daily basis.

It is possible the data that is refreshed to be have the cells color coded?

thanks

[amitchandak]

@jay7519 , Add last refresh date in the table

https://www.enhansoft.com/how-to-add-the-last-refreshed-date-and-time-to-a-power-bi-report/

You can create a color measure and use that in conditional formatting using field value option

example

Color Date = if(FIRSTNONBLANK('Date'[Date],TODAY()) <today(),"lightgreen","red")

refer if needed

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4