Forum Discussion
x-File
Helper I
Helper ICreate two visuals where one stays static when refreshed
Hi all, My colleagues would like to see the two-weekly difference in invoiced milestones. In other words, they'd be happy to open the rapport today and see the upper graph that will refresh, and ...
amitchandak
Super User
Super Userx-File , if this is not two weeks behind data, then you need to create snapshots
By appending the Data
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/
If that is just two weeks behind then you can WOW by making last week's measure 2 weeks behind
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8