Forum Discussion
ssspk
2 years agoHelper 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 f...
ssspk
2 years agoHelper III
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
2 years agoSuper User
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.