How to set the Date Slicer between End date as Refresh date of Dataset everyday happens?

[ssspk]

Hello Team,

I have a Date Slicer Between and it has From date To date selected by default based on the date available.

Also i have a scheduled refresh every day.After refresh is completed To_date field should point to the date max date available from the dataset refreshed by default. A of now customer has to use the slider every time to the latest date updated.

This is not hapening as of now.?

Thank nad Regards,

Siva

[lbendlin]

Drop the slicer and use the Filter Pane.  It has automatic absolute and relative date options.

[ssspk]

Hi @lbendlin ,

Thank you for your time nad reply. But Filter pane we can't handle Start_date and To_date selection. Mostly it will be heplful for combobox type selection.

I have create custom_table called "Date_Filter".

Date_Filter = UNION(

    ADDCOLUMNS(DATESBETWEEN(dashboard_running[event_date],TODAY() - 30,TODAY()),"Type","Default"),

    ADDCOLUMNS(CALENDAR(MIN(dashboard_running[event_date]),MAX(dashboard_running[event_date])),"Type", "Custom"))

If i select custom radio button and Change the Start_date and Change the To_date 30 days before then, Default radio button is hidden. I can't make the button always visible in screen. All are Slicers only.

How to handle it?

Thank you. 

[lbendlin]

This seems to be a very convoluted setup. Make sure this is really what your users want, and even then you should challenge them.  Better spend the time training them on the Filter pane.