How to filter visual by custom date

[Anonymous]

I am currently using one of my columns to filter out my data; however, I do not see any filter that fit my needs:

1. I need to filter all records from current year to today.

2. I need to filter all records from current year up to yesterday (Today()-1)

How can I do this?

[MFelix]

Hi @Anonymous ,

When you are refering that you are using the filter is it on the Filter pane or on using a slicer?

If it's the filter pane you can use the advance options that allows to have a relative date option and that includes or not the current date.