Forum Discussion

ssspk's avatar
ssspk
Icon for Helper III rankHelper III
2 years ago

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

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

 

Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

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

    • ssspk's avatar
      ssspk
      Icon for Helper III rankHelper III
      2 years ago

      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's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

        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.