How to highlight changed values after every refresh

[Anonymous]

Hi All,

I have requirement to highlight or detect only those values which are changed after refresh.

lets say I have data as below 

Before refresh

country |ID |Date Range

US         1     20190201-20200201

UK         2     20170201-20200101 

US         3     20180201-20190203 

After refresh

country |ID |Date Range

US         1     20190301-20200301

UK         2     20170201-20200101 

US         3     20180201-20190203 

So I want to Highlight only   (US         1   20190301-20200301)

How can I acheive this requirement .

Regards,

Praveen

[v-jayw-msft]

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.

[edhans]

@v-jayw-msft - how would it know what the old data was? when it refreshes, everythign is "new" so it all has the same refresh time.

[edhans]

You cannot detect each individual record change. I think you will need to have a "last refreshed data" and "current refreshed data" table and compare for differences. This will require some way to backup/copy the refreshed data so it becomes the last refreshed data. 

Or if your data source could add time stamps to each record and then you compare that timestamp to the refresh time, but that still means you need to know when the last refresh time was, which means a table keeping track of your scheduled refreshes, which would be an estimate. A refresh at 8am doesn't always happen at 8am depending on how many other reports you have refreshing then and the system's overall load. I've seen them launch as late as 15-20min later.