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 dropdown or anything. I need to to be a slicer. I know it is still not a feature in Power BI yet. Any workarounds ?

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

     

1 Reply

  • 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