Forum Discussion

stags14's avatar
stags14
New Member
7 years ago
Solved

Dynamically change slicer

I have a slicer that contains a list of vaues ranging from 1 to 13. These values represents periods in the financial calandar.    When a report opens, I want to default to the current period being ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    I don't think this is supported but you could do something like create a calculated column, where you would compute the current period as 1, and then the second as 2, then 3, 4, ..., 13. Then put that column as a slicer on your page and select 1 and publish it like that. If a month is a financial period then the calculated column could be something like:
    MonthOffset =Datediff(Today() - << your date >>, Today(), MONTH)

     

    Hence, the slicer is not selected dynamically (always 1), but the page is always filtered on current period when you open the report.