cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
danielsouza Regular Visitor
Regular Visitor

How to restrict date in the slicer/filter

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?

 

Capturar.JPG

 

 

Thanks a lot

Daniel

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: How to restrict date in the slicer/filter

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.

 

Calendar.gif

Regards,

MFelix

 



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




7 REPLIES 7
Super User
Super User

Re: How to restrict date in the slicer/filter

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




danextian New Contributor
New Contributor

Re: How to restrict date in the slicer/filter

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

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
www.linkedin.com/in/danebelarminocpa
danielsouza Regular Visitor
Regular Visitor

Re: How to restrict date in the slicer/filter

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:

 

Capturar.JPG

 

 

 

danielsouza Regular Visitor
Regular Visitor

Re: How to restrict date in the slicer/filter

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

Super User
Super User

Re: How to restrict date in the slicer/filter

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.

 

Calendar.gif

Regards,

MFelix

 



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




danielsouza Regular Visitor
Regular Visitor

Re: How to restrict date in the slicer/filter

Thanks man! That's it!

 

How can you record your screen like that?

Super User
Super User

Re: How to restrict date in the slicer/filter

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

 



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!