Forum Discussion
Create 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 the bottom one that won't so they can see which exactly has changed in two weeks time (see for example attached picture - which has two exactly simlar visuals, which is NOT what i want, only for the example :-)). I suspect it has to do with a couple of things, that I'm not too familiar with, so any help would be reaaaaaly appreciated :-).
The data comes from an SQL database. If anyone could help me, it'd be very very happy to share my actual file with them!
Thanks a lot in advance,
Felix
4 Replies
x-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=pnAesWxYgJ8Hi amitchandak ,
Thank you so much for your answer. I'm not that good with power Query and DAX I'm afraid, although I did give it a shot - didn't work. The problem is (I think), that the data is coming from our AFAS-program, which contains al the contract, but it changes ongoing - so milestones get invoiced etc (with an invoice date and "True" or "False" for when they are invoiced. So am I right that, after thinking more about it, I can not make this visible? Otherwise, I'd be happy to share my dataset with you in private and see what's possible :-). Thanks inadvance,
FelixHi amitchandak ,
I was afraid as well.. it's probably the only solution to create snapshots I'm afraid, because allthough it's indeed two weeks behind, our program doens't work that way since in Afas, changes can be made undone and so a table from two weeks ago won't be exactly the same as a table from now.Hi amitchandak ,
Thanks for your answer, however it's not that simple I'm afraid. I could send you my file inlcuding what needs to be done (even though I'd like to try myself), but after looking at your suggested links, those are not the solutions I'm afraid.
Best,
Felix
