Forum Discussion
Setting a Default Value for a Slicer
Hi Everyone, I hope you can help me on this. This issue has been discussed in few other posts and apparantly some solutions been suggested, but none could help me. I try to explain it in a c...
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
The solution is available in this video.
In summary, Need to create a defualt measure 1(which filtered for the latest date) then based on the user choosen date measure 2 willl be shown.
https://www.youtube.com/watch?v=tXdze9PxYIg
Mark as asnswered if it solves your problem