How to highlight changed values after every refresh

Hi Anonymous ,

You need to define a date as last refresh date like create a calculated column.

Column = NOW()

then use the date range compare with the column.

if(date range=column,1,0)

After that you can use conditional formatting feature to hightlight the changed values.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.