Forum Discussion

ptmuldoon's avatar
ptmuldoon
Icon for Resolver I rankResolver I
1 year ago

Dynamic Date Filter daily/monthly

I have a filter on various report for "Daily" and Monthly".    Is it possibly to create a Date filter where if the user choses Daily, the date filter would show each day/date?  And then if they chose Monthly, that same date filter would only show the month end dates?

Need Help

4 Replies

  • Selva-Salimi's avatar
    Selva-Salimi
    Icon for Solution Sage rankSolution Sage
    1 year ago

    Hi ptmuldoon 

     

    you can use bookmark to fulfill this expectation

     

    If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi ptmuldoon ,

     

    You can also try the field parameter. I made a sample for you.

     

     

    Best Regards,

    Wearsky

    • ptmuldoon's avatar
      ptmuldoon
      Icon for Resolver I rankResolver I
      1 year ago

      Thanks.

       

      The above works very well.   But could you possibly assist on to maybe then Filter that date/month down to X number of dates or months?   

       

      Ie, when chosing daily, list out the laxt X days.  And similar for the months?     I was trying to add a filter within the parameter, but could not get that to work.  

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi ptmuldoon ,

     

    Here is the sample about month.

    Create a numeric parameter to show last x months.

    Parameter Value = MONTH( MAX('Table'[Date]))- SELECTEDVALUE('Parameter 2'[Parameter])

     

    Best Regards,

    Wearsky