Limit Data Range

[FeelTheFlow]

Hello Guys, 

I would like that the final user of the report have the posibility of choose first 1.1.2018 and not before. 

Is it any way to make previous dates unable to use?

I will strongly appreciate any help!

[Anonymous]

@FeelTheFlow 

1. If the final users do not have the permission to change the filter panel you can used the method provided by @darentengmfs , adding filter to the date Slicer. 

2. The other method is just create a new date column next the old date column, and use the new date column as the slicer. 

New Date column = IF([Date]>=DATE(2018,1,1),[Date])

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[darentengmfs]

Hi @FeelTheFlow 

Click onto the Slicer, over at the Filter Panel, under "Filter on this visual", filter it by the date you want, in this case Date, with the Filter Type to be "Advance Filtering", and it will be IS ON OR AFTER 1/1/2018.

If you want the whole report to only show data from 1/1/2018, put the Date into "Filters on all pages", and do the same criteria.

[FeelTheFlow]

Thanks! This is a good option but it seems that it just limits the slicer, I send you an Screenshot:

[Anonymous]

@FeelTheFlow 

Set filter on the this page instead of filter on this visual.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[FeelTheFlow]

I get the same results: