Freezing a matrix visual on the 1st of every month!

Hi guys,

I’m currently working on a dashboard which was almost complete until my CEO came in and asked me to create a new matrix which he wants to freeze and doesn’t want it to get updated after the 1st of every month. In other words, he wants collection rate to freeze of the last month until the 1st of the next month reflecting the CR% for the previous month.

Since my dashboard gets updated everyday with the new data, is there anyway where I can achieve the above objective where that particular matrix doesn’t get updated like the rest of the visuals in the dashboard.

I’m open to all unconventional methods that I can employ to achieve this objective. Please help me out.

Thanks in advance.