Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

How to highlight changed values after every refresh

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

 

 

3 REPLIES 3
Anonymous
Not applicable

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.

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



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
edhans
Super User
Super User

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.