Forum Discussion
Track changes from dataverse table
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?
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
2 Replies
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-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/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
