Thanks Joy, but no luck. The sliders don't automatically update- you need to update them yourself every month. That's not a good way.
I want the filter to be able to select only the most current date. So now it would show July, in August it would show August, etc...
There are a few options you can try, first is using a discrete date and putting it into the filters shelf. You have the ability to tick on the option 'Filter to latest date value when workbook is opened':
2) Second is create a fixed calculated field and using it in your filters shelf and setting it to true:
3) The third option is the same as Joy's, however you need to remember to RESET the filters. This will update automatically as the data updates:
In the show filter, click on the filter funnel so that the x disappears: