topic How to set the Date Slicer between End date as Refresh date of Dataset everyday happens? in Custom Visuals Development Discussion

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

ssspk — Fri, 30 Aug 2024 10:12:04 GMT

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

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

lbendlin — Fri, 30 Aug 2024 12:52:37 GMT

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

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

ssspk — Mon, 02 Sep 2024 12:30:41 GMT

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.

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

lbendlin — Mon, 02 Sep 2024 14:35:18 GMT

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.