Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I know this is an old one but I can't find a clear answer.
I have a bunch of bookmarks which apply pre-filtered hidden slicers, so each bookmark shows the same matrix just filtered to specified requirements.
However there are also visible slicers, for year and quarter etc. If a user selects a year, and then moves across the bookmarks it clears their year slicer. How do I keep it?
Also I applied a page level filter which I then had to apply to each bookmark as that was disappearing as well.
Solved! Go to Solution.
In the end I had to create multiple tables, filtered at visual level, and the bookmark shows/hides the tables accordingly. Then I can turn Data off the bookmarks and it allows the slicers to work across them. Hard work but it achieves what I need.
In the end I had to create multiple tables, filtered at visual level, and the bookmark shows/hides the tables accordingly. Then I can turn Data off the bookmarks and it allows the slicers to work across them. Hard work but it achieves what I need.
Agree. As of today, and to my knowledge, this is the only to way to have full control over the filter interactions in this case.
Hi @JemmaD
Please ensure you uncheck the Data on the bookmark. Right click your bookmark and uncheck.
Thanks
Hari
That stops my bookmarks filtering altogether. IUnless I can pre-filter my table using something other than slicers I think i'm stuck with the bookmarks removing the filters. How irritating.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
87 | |
84 | |
68 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
71 | |
67 |