March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
133 | |
91 | |
88 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
73 | |
68 |