Set DATE slicer default to FROM: 1st date of current month & TO: current date or latest record date

[garich]

Hi,

How would I set the DATE slicer default below to make it:

FROM: 1st date of current month

TO: current date or latest record date

Please note that I didn't use a DATE table in this case and just used a date field from one of my tables.

[v-yaningy-msft · Accepted solution]

Hi, @garich 

Based on your description, I have created some measures to achieve the effect you are looking for. Following picture shows the effect of the display.

Measure:

DateSlicer =

VAR _end =

    TODAY ()

VAR _start =

    EOMONTH ( TODAY (), -1 ) + 1

RETURN

    IF (

        SELECTEDVALUE ( 'Table'[date] ) <= _end

            && SELECTEDVALUE ( 'Table'[date] ) >= _start,

        1

    )

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Idrissshatila]

Hello @garich 

it won't work in the between setting, you could use relative date setting

[garich]

Thanks for your response. However, using this setting has a limitation which user cannot choose the date ranges they want specifically.