Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Save data in visuals despite source updates

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

Need Help

1 Reply

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi Anonymous 

    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