How to set dynamic defaults on slicers?

[adityah]

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 ?

[JoeBarry · Accepted solution]

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