Forum Discussion
Setting a Default Value for a Slicer
Hi Anonymous,
My way of handling this requirement was to create a calculated column in the date dimension "IsYesterday", which was a formula and either said "Yesterday" or "Other Dates".
I used this as a slicer in my report, alongside the normal date slicer and selected "Yesterday" in the "IsYesterday" slicer.
Then I told my users that they can select other dates by clicking the "Other Dates" option on the "IsYesterday" slicer.
Hope that makes sense and helps,
Alex
Hi Anonymous,
My way of handling this requirement was to create a calculated column in the date dimension "IsYesterday", which was a formula and either said "Yesterday" or "Other Dates".
I used this as a slicer in my report, alongside the normal date slicer and selected "Yesterday" in the "IsYesterday" slicer.
Then I told my users that they can select other dates by clicking the "Other Dates" option on the "IsYesterday" slicer.
Hope that makes sense and helps,
Alex
Thanks alexei7, it's a good idea and worked for me. I might a bit overcompleicated it by only wanting one slicer in the page, but this is good and does the job.
Anonymous alexei7 : I am in the same boat and i created the two slicers as suggested in this thread but when i select yestarday in the report in slicer the other normal date slicer is still showing the range instead of from and to date pointing to yesatrday which is creating confusion to my users . I am attaching the screenshot in below .
If you dont mind can you send reply alogn with the implemnted screenshot that helps for me. In below latest date was "3/18/2019" but the filter showing 5/4/2018 to 3/18/2019 which is confusing the users