Create a filter with year saying as current year and previous year and drill down to years

[msbiuser1]

I want a slicer with year and want parent level as current year and previous year. Also i need to drilldown to corresponding years.

My intention is to make my page always filtered to current year when user opens the report. Viewpoint required. 

Thanks in advance

[saravanan_p · Accepted solution]

Hi, you need to create a caluclated column in date table with if condition.

CY_PY = if(year(date) = year(Now()),CY,PY)

Use this column first in filter and drag year column next to that.

Click the CY checked and publish the report.

Your are done.