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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Kudoed Authors