In my report, I have created 5 bookmark buttons. Two bookmarks called 'Excluding' and 'Including', and three options for each of the bookmarks to toggle between Last Year, This Year and Forecast. I also have 10 slicers on the page.
The two bookmarks have different filters applied to them. One has a filter which excludes some revenue types and the other does not have it. So, when Excluding is clicked, Last Year, This Year and Forecast should all have the "excluding [...]" filter applied, and when Including is clicked, there should be no filters on Last Year, This Year and Forecast.
The problem I have is that if I want the slicers to stay the same across the bookmarks, I have to uncheck the 'Data' option on the bookmarks. However, if I do this, I either loose the filter applied to the 'Excluding' bookmark, or the 'Excluding'-filter is applied to the 'Including' bookmark.
When I check the 'Data' option in the bookmarks, the filters are correct, but the slicers are erased/defaults back to the saved bookmark view. If I uncheck 'Data', the selected slicers stay the same across the bookmarks, but the filter is incorrect.
Is there a way to make sure that the correct filters are applied to the bookmarks, while still maintaining the slicer options?
