In between date slicer should set to refresh date

[vvangur]

Hello,

I have between date slicer where I can select 'start date' and 'end date'. But the user want to see the end date should be change to max date dynamically whenever the data get refreshed. 

Can anyone help me on this?

Thanks

[Lesposto]

Hoping to be helpful for someone who is looking for a date slicer (showing the MIN and the MAX date of a Calendar[Date] column) which will refresh every day with the new MAX date, I found that if you create a slicer in Power BI Desktop and just upload the report on the Service, without using the slicer, the MAX date will be automatically updated every day. On the other hand, if you create the slicer in PBI Desktop and use it before uploading the report to the Service, then the MAX date will remain the one the report had when you uploaded it. So the point here is to create the slicer and don't use it in the Desktop (never).

Personally, when I need to explore data using a date slicer, I always create a new page with an independent date slicer that will never be uploaded on the Service. Doing this I preserve the "refresh ability" of the date slicers of all the pages of the report.

[kpost]

Thank you for this insightful post.  I have noticed that some of my pages automatically refresh to the latest dates and some of them do not, and I could never figure out why!  Thank you for solving this mystery for so many people experiencing this issue.

[Lesposto]

You are welcome! Anyway doing this we can solve the problem for the MAX date, which will automatically update to the latest date in the DB, but we still experience problems with the MIN date, which can't be set by default. I mean, if you have 3 years of data and you create a date slicer, it will select 3 years of data, which could be expensive.

It would be great to have the possibility to set a default value for both MIN and MAX date of the slicer, so that the report can always open in a predetermined range. I found many ideas in the "Ideas" section, but none of them have enough votes. Maybe merging some of them could improve our chances to be heard by Microsoft, but there are many of them.

[sohananahid]

I also having similar issue. I have in between Date slicer using "Date" col from  "Date Table". 

Date Table = CALENDAR(min('Procedure Content'[Content Created Datetime]), TODAY()). 

When latest "Refresh" date is 9/14/2023 [which is today], the Date slicer right most edge points to the date the Power BI report was published [8/18/2023].

The user of the Report wants the slicer 's right edge adjust automatically to the latest Refresh date, hence to 9/14/2023 as of today. Any suggestion? Many thanks.

[V-pazhen-msft · Accepted solution]

@vvangur 

You can not make slicer to have default slicer. Instead, if the user wants to have the value between the start date to max date, you can create a measure to achieve this.

1. Create a distinct table:

Table 2 = DISTINCT('Table'[Date])

2. Create a measure:

Measure = CALCULATE(SUM([Value]),FILTER('Table',[Date]>SELECTEDVALUE('Table 2'[Date])))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Not really sure what you are looking for, can you give some more examples. If I understand correctly the end date in your slicer should only show the max date of your particular table, right? So if you have the slicer connected to that table, it will only show the min and max dates of the Date column in that table anyways. If you have added a Calender Table for example, then you might only get the min and max of that table. If that's the case I would suggest to relate both of them, and use the source table in your slicer. That source table is then linked to your Calendar Table, so you can use it in other visuals and/or tables as well.