Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ssspk
Helper II
Helper II

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.?

 

date_filter.png

 

Thank nad Regards,

Siva

 

3 REPLIES 3
lbendlin
Super User
Super User

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

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?
 
date.png
 
datess.png
 
date_hidden.png
 

 

Thank you. 

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.

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Top Kudoed Authors