Creating a Month To Date filter

Workbooks
1

You’re using Period-Over-Period to compare this month to last month.
image

However, today is only the 27th of August. So we’re comparing 27 days of August with the whole 31 days of July. Instead, we want to compare the 27 days of August with first 27 days of July. We can do that by changing the “Current Period” filter condition:

image

Now, we are getting a MTD comparison:
image

If you want to see an alternative approach that allows for more dynamic selections in the dashboard, then check it out here: How can I dynamically show YTD/QTD/MTD metrics in the KPI tiles on my dashboard?