Relative date filtering for month + day across several years

[Anonymous]

I am trying to compare values for a Day of the Month across various years. The goal would be to show a table comparing values like the following but only showing Day of the Month equal to yesterday's date from this year & last year.  I cannot figure out how to get dynamic filtering to work, given my "Date" or Day of the Month field is just a text field. I created it by extracting Month Name + Day, then merging the two into one column. 

Anyone able to help me figure out how to achieve this relative filtering?

Thank you! 

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may add an appropriate measure to Visual level filters.

https://community.powerbi.com/t5/Desktop/Use-a-date-slicer-to-filter-on-a-period-instead-of-a-single-date/m-p/588265#M278953