Auto Forced Selection in Slicer for Current Year in Chiclet Slicer

[Prodosh]

Hi All,

I have a requirement in my report that i need to give a forced selection of Year which i can do with chiclet Slicer, but the forced Year selection should be Max or current Year.

My data source is SSAS Live Connection so a limitation to create custom fields or table is there.

Also apart from the max year selection in Chiclet slicer the other values of year should be also available in the slicer.

Any help can be appreciated.

Thanks in advance.

[Anonymous]

It is not possible to do that. You can set a fixed default value for the slicer, but not a variable one.