Forum Discussion
In between date slicer should set to refresh date
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.
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.
kpostSolution Sage
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.
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.