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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
ssspk
Helper III
Helper III

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors