Issue with Slicer Not Updating to Latest Order Date Upon Dashboard Refresh

[Praj8050]

I have encountered a challenge with a date filter in my Power BI dashboard. Currently, I have implemented a slicer on the "Order Date" field, allowing users to select a date range between a "From Date" and a "To Date" using the "Between" selection option. However, each time the dashboard is refreshed, the "To Date" does not automatically update to the latest available order date.

For example, at the time of publishing the dashboard, the latest order date was September 1st. When I reviewed the dashboard two weeks later, the "To Date" in the slicer remained set at September 1st, even though more recent order data was available.

I attempted to use the "Relative Date" option in the slicer, but it does not provide the functionality to select between two specific date ranges, which is critical for this use case.

Could anyone kindly suggest any alternative methods to ensure that the "To Date" is automatically updated to reflect the latest order date whenever the dashboard is refreshed?

[mussaenda · Accepted solution]

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

[araoim]

Had a similar issue with between slicer and I found the solution in a tutorial and worked for me.
The ideea is that when we create a between slicer in Power BI Desktop if we want to test it to see if is working properly we need not to touch it in desktop, but publish the report on service and test it there on the workspace. Once you select certain values in destop, for a between slicer, even if in the end you select all possible values, Power BI will hard code those values available on desktop and when you publish the report and deploy it to another environment, after refresh you will see the selection made in desktop. Power BI thinks that this is what you wanted to be selected by default, and you need to manually drag the slider to see the latest data.
The problem is that we need to be carefull when we made other developments in the future for this report, and not touch the between slicer, otherwise we need to deleted created again and only then to publish the report.

For me this solution worked.

[Anonymous · Accepted solution]

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.

[mussaenda · Accepted solution]

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

[Praj8050]

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.

[dharmendars007]

Hello @Praj8050 , 

To tackle this scenerio you can have flag filtering the dates which is untill latest..

Create this calculated column in your date table -->>> MAX('YourTableName'[Order Date])
Next add this calculated clumn to flag the date ->>>> "Is Latest Date"= IF([Date] = MAX('YourTableName'[Order Date]), 1, 0))

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

Thank You

Dharmendar S

LinkedIN