Track changes from dataverse table

[mwinds]

Hi all,

I'm trying to see if there is a way to highlight a change to a project that I'm recording on a table on dataverse. For example, if the status of the project changes, I'd like to show that in a graph. 

I'm really unsure how to do this as as far as I'm aware Power BI and dataverse only use current data, and doesn't look at data that was previous in the record.

Anyone know how to do this?

[Anonymous · Accepted solution]

Hi  @mwinds ,

I created some data:

Would you consider adding a time field to the table that records the time of day for all data records, and using measure to determine the date of previous data to highlight?

Customized rules: Previous data date: 2024.2.4

Here are the steps you can follow：

1. Create measure.

color =
var _previousdate=DATE(2024,2,4)
return
IF(
    MAX('Time_Table'[Date])>_previousdate,"red")

2. Select [ID] – Conditional formatting – Background color.

3. Result:

Best Regards,

Liu Yang

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

[amitchandak]

@mwinds , For that you need to create snapshots.

Check if this can help

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/