Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Date Slider with set dates

Hi

I need to create a date slider that specifies 'Last 7 Days', 'Last 14 Days' and 'Last 21 Days'. Is this possible to do with DAX (measure) i.e. no backend table changes, and if so how can it be done?

Thanks!

Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi Anonymous ,

     

    Based on your description, you need to create a disconnected table as slicer option, through which you can switch measure.

    You can refer to the sample .pbix

     

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

5 Replies

  • amikm's avatar
    amikm
    Helper V
    5 years ago

    Hi Anonymous, we have pre-built logic in the Power BI desktop



     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks Amit - Ideally I need 4 buttons, one for each of those periods and one that clears them and completely unfilters the page. Is this possible to use in a slicer?

       

      • amikm's avatar
        amikm
        Helper V
        5 years ago

        In that case, might be you will get landed with multiple slicer and one button that can reset the entire page that you can do with bookmark and selection pane.

         

         

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    Based on your description, you need to create a disconnected table as slicer option, through which you can switch measure.

    You can refer to the sample .pbix

     

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.