Forum Discussion

adityah's avatar
adityah
Frequent Visitor
3 years ago
Solved

How to set dynamic defaults on slicers?

Hi,   Posting this question since I did not find anything similar on the forum.   I want to create a filter with the default as today - 64days till today+32 days but I do not want it to be a drop...
Need Help
Tips and Tricks
  • JoeBarry's avatar
    JoeBarry
    3 years ago

    Hi adityah 

     

    In your date table add a new column

    DatesRange = if('DIM Date'[Date] >= TODAY() - 64 && 'DIM Date'[Date] <=  TODAY() +32,1, 0)

     

    Add a slicer with the normal date column in it. in the filter bar add the new column and choose filter type Basic filtering and choose 1 and apply filter

     

    Thanks

    Joe

    If this post helps, then please Accept it as the solution

     

JoeBarry's avatar
JoeBarry
Icon for Solution Sage rankSolution Sage
3 years ago

Hi adityah 

 

In your date table add a new column

DatesRange = if('DIM Date'[Date] >= TODAY() - 64 && 'DIM Date'[Date] <=  TODAY() +32,1, 0)

 

Add a slicer with the normal date column in it. in the filter bar add the new column and choose filter type Basic filtering and choose 1 and apply filter

 

Thanks

Joe

If this post helps, then please Accept it as the solution