How to show a zero value in the KPI widget

I'm using a KPI widget to track week by week sales performance. I have it set up to be grouped by date and then show as latest.

My problem is that If I don't have a sale in the last week, the widget takes the value from the week before. How can I configure it to show me a value for the week I need rather than a value closest week with non-zero sales.