Forum Discussion
How to set default MAX date in Slicer
Thanks a lot, Sergii24. It works! I would like to show the maximum date as a date value,
example : Maximum date 14/09/2023 , is this possible, please. thanks
I'm glad it helped, Guru123 ! Unfotunately you can't add the date itself there as the whole concept is to make sure that your slicer value is static (so doesn't change after refresh).
You can add a "selected period" label somewhere in your report to underline what date is selected.
Remember to mark answer as solution so others can easily find it if the face a similar problem 🙂
Have a great day!
Super UserI'm glad it helped, Guru123 ! Unfotunately you can't add the date itself there as the whole concept is to make sure that your slicer value is static (so doesn't change after refresh).
You can add a "selected period" label somewhere in your report to underline what date is selected.
Remember to mark answer as solution so others can easily find it if the face a similar problem 🙂
Have a great day!
Can you please elaborate this approach what you mean there?
I tried your above suggested solution but I want to use my slicer in "Between" slicer style since the date range is really long. Now because the calculated column now becomes a text column, it wouldn't work for this style.
If there is a way that I can manipulate tmy slicer to show the last date value by setting an underlying value or filter somehow in a between style slicer, I would be great.
Hi Swathi,
Even I am using the same "Between" Style in my Date Slicer - Whenever I am manually refreshing the Data, then The Upper Limit in the Date Slicer is not getting updated to the latest date - It is still showin the Old Date
Please refer to this YouTube video. This may help.
https://www.youtube.com/watch?v=D4AF9lQCickBrilliant, yet so silly.
To summarize: Add the date slicer, but don't touch it after that, and it will dynamically adjust.
- Sergii24
Hi Anonymous, the idea of this approach is to have a some static value filtered, so whenever you refresh a report it remains invariate (even if behind the scene the date or date range has changed).
Because of using a static string value, a new calcualted column is not of type Date anymore but Text. Therefore, you can't expect the same behavior as if it would be a date type column when using this column in a slicer. I don't think it can be changed as you can't mix different data types in the same column.
I hope it helps!