cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
danielsouza Helper III
Helper III

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 III
Super User III

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

 


Regards

Miguel Félix


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

Proud to be a Datanaut!

Check out my blog:

Power BI em Português





View solution in original post

7 REPLIES 7
Super User III
Super User III

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


Regards

Miguel Félix


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

Proud to be a Datanaut!

Check out my blog:

Power BI em Português





Super User I
Super User I

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.






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

Proud to be a Super User!







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

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 Helper III
Helper III

Re: How to restrict date in the slicer/filter

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

Super User III
Super User III

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

 


Regards

Miguel Félix


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

Proud to be a Datanaut!

Check out my blog:

Power BI em Português





View solution in original post

danielsouza Helper III
Helper III

Re: How to restrict date in the slicer/filter

Thanks man! That's it!

 

How can you record your screen like that?

Super User III
Super User III

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

 


Regards

Miguel Félix


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

Proud to be a Datanaut!

Check out my blog:

Power BI em Português





Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors