Forum Discussion
Helper IIIPrevious month selected automatically from drop-down slicer
However I was hoping the slicer display would still show the 'Mar-26' date in the slicer instead of 'previous Month.' Unfortunately, this is not possible. The key of this workaround is being alphabetically different and always be on top of the slicer. Maybe you can add
var _monthName = FORMAT(_previosMonthEnd, "MMMM")
and
"Previous Month (" & _monthName & ")".
If this solved your issue, please mark it as the accepted solution. ā
Super UserIf you are ok with the custom visual, check this one out. Little buggy but ok it works
Preselected Slicer
Note: This is NOT my app visual. It has a sample file to play with it.
- anilelmastasi
I don't understand why product team develop a slicer like this, instead we are doing workaround. I know this visual but I haven't use in my reports. My biggest client (3000+ user) used this developer's Mass Filter in prod and it works ok.
- sevenhills
Usage wise, it is simple and helps folks like analsysts. With few steps easy to achieve the functionality.
In my view, I did not dig, but thinking as short cut to Reusable Time Intelligence Calculation Groups with TMDL.