Label Filter Does not contain specific date

Hi,

I am supposed to analyze sales for a certain period. Let's say 1 Jan 2018 until 28 Feb 2019.
The year filter would be 2018 and 2019. In the months I have to select 1-12. The problem now is that I also get the data for March and April 2019 which I don't want.

What would be the best way to filter out these two months in 2019? When I go to the label filter and exclude 3 and 4, it will also exclude March and April in 2018.

Any help is greatly appreciated.

Thank you!

Jensen

Hi Jensen,

What I'd do is create a new data set on which to filter. It would contain both the month and the year. For date you can always have the first. For example something like this:

Month
01/01/2018
01/02/2018
01/03/2018

This way you could filter on the column or create a slicer without having unnecessary fields.

Hope this helps!