How to restrict date in the slicer/filter

[danielsouza]

Good morning

I have calendar table, and another table that contains days, months only for 2017, but in the report slicer I can select dates from 01/01/2010 to 18/05/2037!!!

Can I restrict this, according some criteria or table?

Thanks a lot

Daniel

[danextian]

Alternatively, you can also filter out the dates you don't want using advanced filtering option under report-level filters.

[danielsouza]

@danextianare you refering to the second option given by @MFelix?

[MFelix]

Hi @danielsouza,

I see one of two ways of doing this:

Change the start date of your generic date table to make it to the  2017 start and end today that way the table will grow in time.

Add the generic calendar date to Report filter option and choose the starting from 2017 or a relative slicer with the last X months, days, years.

Regards.

MFelix

[danielsouza]

Hi @MFelix, I cannot change the initial time of my generic date table because I'm using it to another reports with distinct dates intervals.

The second option I don't know how to do this...

dCalendario is the generic table:

[MFelix · Accepted solution]

Hi @danielsouza,

In the visualization at the bottom you have 3 options for filters: Visual Level filters, Page Level Filters and Report Level Filters.

Add your date column to your page level filter and select 2017, there is also option for relative date filter.

Regards,

MFelix

[danielsouza]

Thanks man! That's it!

How can you record your screen like that?

[MFelix]

Hi @danielsouza,

I use and application to make a GIF image.

Check http://www.screentogif.com/ and it's pretty easy to use.

Regards,

MFelix