To me, it sounds like a possible solution is to do a sheet swap with a vertical container on a dashboard. You would create a calculated field that shows "Data Not Available" text if the user selects a date outside of your data set date range.
Take a look at the attached and see if what I'm describing would help you.
Data Not Available.twbx 1.2 MB
Thanks Keith. Your solution gave me an idea to achieve what I intended to. My requirement was bit different to what you have implemented but it did get me thinking and come up with a solution.
Appreciate you sharing your idea. It's great !!