Forum Discussion
Solved
Subscription preview image filter update
We have an email subscription with a preview image showing a page filtered for the current month (via dropdown slider). Each month we edit the report in the service by changing the slider to disp...
It's a pretty standard pattern, but it requires the calendar table to be in import mode (or a calculated table) and the dataset to be refreshed daily-ish.
- Create a calculated column that marks the appropriate rows in the calendar table as "current month" and all others as the string representation of their month
- use that column in the slicer
- set the "current month" value as the default
- publish the report.
Each month we edit the report in the service by changing the slider to display the current monthHave you considered using a more automated version that always shows the most recent month as the default?