Setting default date range in slicer

[V504942425U]

Hello,

I have placed date slicer. It is displaying default start date as 11/1/1899.

How to change default start date to 11/1/2017 & end date value to today.

Please help out to solve this problem.

[jdbuchanan71 · Accepted solution]

Add a calcualted column to your date table like this.

Show = 'Date'[Date] >= DATEVALUE("11/1/2017") && 'Date'[Date] <= TODAY()

Then add that field as a filter on your slicer and set it to only show TRUE

[Anonymous · Accepted solution]

Hi @V504942425U ,

As far as I know, calculated column will take up memory. And Power BI doesn't support us to add a measure into slicer. I suggest you to create a measure and then add this measure into the visual level filter.

Show =
VAR _DATE =
    SELECTEDVALUE ( 'Table'[Date] )
RETURN
    IF ( AND ( _DATE >= DATE ( 2017, 11, 1 ), _DATE <= TODAY () ), 1, 0 )

Add this measure into the visual level filter of your slicer and set it to show items when value equal to 1. Result is as below.

By Default:

Add measure into visual level filter:

Best Regards,
Rico Zhou

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

[jdbuchanan71]

@Anonymous 

It is the cardinality of the data that determines the amount of memory the columns takes so a True/False column will take up very little memory in the model.  On my dates table, I have a column 'Is Past' that is a True/False and it uses 1.3 kb of memory.

[jdbuchanan71 · Accepted solution]

Add a calcualted column to your date table like this.

Show = 'Date'[Date] >= DATEVALUE("11/1/2017") && 'Date'[Date] <= TODAY()

Then add that field as a filter on your slicer and set it to only show TRUE