Forum Discussion
Default Date selection as current date at Slicer
I need to publish the report to Service such that the default selection for Year and Quarter at slicer is the current Year and Quarter , I have created slicer using Year Hierarchy which includes Year...
Hi Rfingerhut
Could u pls elaborate more regarding this solution would be helpful if u can provide SQL or M code or any helpful link for the same
Thanks
One method could be dropping the "Q" from the quarter, or if you have another field that is just quarter number, then add that number to year. The max value of that column would then be set to "Current" and everything else is just the Quarter - Year value for the slicer. There may be better ways to handle this, but that's what comes to mind first.