Forum Discussion
Issue with Slicer Not Updating to Latest Order Date Upon Dashboard Refresh
- Anonymous2 years ago
Hi Praj8050 ,
Thanks for mussaenda's reply!
And Praj8050 , I did some test but I can't reproduce your problem. Perhaps you can try the following:
Assume this is your Sales table:Use this DAX to create a calculated table for slicer:
Calendar = VAR _MIN = CALCULATE(MIN('Sales'[Date]), ALL(Sales)) RETURN CALENDAR(_MIN, TODAY())
Create relationship:Then you can use the table Calendar to create slicer:
Every time you refresh, the date range in the slicer will always be updated to the range from the minimum date in your Sales table to today's date.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Praj8050 ,
Have you tried not selecting anything in "To Date" and just let it be the max available date.
I am using the between slicers and it updates properly as long as i don't set the date in "To Date"
Hope this helps
- Praj80502 years ago
Helper I
Could you please elaborate further, and if possible, include a screenshot for clarity? In the slicer settings, I have selected the "Between" option, and by default, the "To" date is already preselected.