Forum Discussion

FeelTheFlow's avatar
FeelTheFlow
Regular Visitor
5 years ago

Limit Data Range

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!

 

 

 

Need Help

5 Replies

  • darentengmfs's avatar
    darentengmfs
    Post Prodigy
    5 years ago

    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's avatar
      FeelTheFlow
      Regular Visitor
      5 years ago

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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.