Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Showing Values Less than Date chosen

Hi ,  I have a table in this format    I am trying to choose a date or range (for example when i choose 16-05-2019) the output should be  but if I choose 19-05-19 I will want to see    ...
Interesting Links
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous 

 

You should be able to just create a date slicer visual, drag the date field onto it, and then change it to a date type of "before". This will allow the end user to choose the end date - all dates before it will be included.

 

Hope this helps,

Scott

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Attached screenshot.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Spowell, 

       

      In this example when I  use the before slicer for what happened befored the 19-01-19, it will include the 15-05-19 and  I want to exclude it because it was cancelled on the 18-01-19.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Ah, ok, I don't think I understood. Just to clarify, what you want is for items to show up if their created date is before the selected date on the report AND it hasn't been cancelled before the selected date.

         

        Can you confirm if I have that correctly?

         

        Thanks,

        Scott