Forum Discussion
Subscription preview image filter update
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.
I'd definatley prefer that but couldn't work out a good way of doing it. If you have any ideas, I'd love to hear them.
Users require report to default to current month but be able to select previous months as required (1 full month at a time only).
I wan't this to be simple for users so I went for the slider drop down method. I don't know if I can default it to the current month this way though.
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.