Save data in visuals despite source updates

[chloesouss]

Hello,

I want to save the data for 2023 in the visuals despite the source being updated for 2024.
I would like the 2023 data to be frozen and only the 2024 data to be updated on my visuals. Is that possible ?

 Thanks for your help !

Chloé SOUSSAN

[PijushRoy]

Hi @chloesouss 

If your single table contains both year data
Please use Power Query, break table into two year data (use filter)
Then in 2023 data table, uncheck the option "Include in Report refresh"

Append the 2023 & 2024 data in single table

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin