Forum Discussion

V504942425U's avatar
V504942425U
New Member
4 years ago
Solved

Setting default date range in slicer

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.

 

  • 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's avatar
    Anonymous
    4 years ago

    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.

     

     

3 Replies

  • 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's avatar
    Anonymous
    Not applicable

    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's avatar
      jdbuchanan71
      Icon for Super User rankSuper User

      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.