Thank you for your solution. However if I keep my slicers retained, my page filters data associted with each toggle button are not working. Could you please check and see if I am missing something?
Here is the business use case:
End-user would like to select specific regions and venues and see sub-rental expense, purchsaed expeses and other types of expenses for selected regions and veunes.
My approach is:
1. add Regions and Venues filters
2. create three toggle buttons to intereact show corresponding data (Note: as I am using Live connection, I am not able to group each expense item into , so what I did is to create three bookmark to show each type of expense by applying PAGE FILTER)
For example, I applied filters to filter out other types of expense and bookmark it. Same as Sub-rental and Purchased expenses.
3. create three buttons to link to bookmarks to these types of expenses.
4. Select visuals and exclude "Regions" and "Venues" filters , then update the bookmark.
However, it turned out filters remain the same in different bookmark, but my page filter also remain the same , which should not. as three pages for three filtered set of expenses...
could you plesae check ? Appreciate your help ahead!
As I understand it, you want to keep filters on Regions and Venues BUT you also want to keep your page filters which are different (in function of your choice : sub-rental, purchased or others).
My first idea is to think that even if you're creating bookmarks, you are still working on the same page (& same filters).
Did you try to apply your filter not on the page but on the object(s) ? For example, instead of applying this filters on page, apply them on your different objects (table, graph...). You'll need to repeat the action for each of your 3 pages and begin again the operation (select everything except your slicers, then update your bookmark).
What if your page has many objects as in my case (I've 8 different objects) and to apply individual filters would be really cumbersome and what is client expects to have a filter which affects all the visuals in one go rather than applying individual filters?