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
Hello,
I made a report wich is embebed in a https web site and filter by URL when called.
In this report, I use 2 bookmarks to apply/remove one filter on another field this the one filter by URL.
The bookmarks are defined whith the options DATA/DISPLAY/ALL VISUALS to handle both the filters and the display of the buttons related to the bookmarks.
My problem :
As soon as I use one of those bookmarks, the filters related to the bookmarks in the PBIX file are applied "from scratch" to the data and not ontop of the filter in the URL so that the filter in the URL is no more applied and all the hidden data are visible !!!
Of course my goal was that the filters of the URL was ALWAYS applied to the report.
I saw this thread https://community.powerbi.com/t5/Service/Bookmarks-remove-report-level-filter/m-p/294761#M34464 but in their case, they only adapt VISUALS.
In my case, the bookmarks have to filter the data on a column and remove this filter, always keeping the URL filter (on another column) active.
How to achieve this ?
Thx
Hello, it has been solved (?) I have the same problem. I know I can use bookmarks and uncheck the Bookmark Data property to keep the URL filter, but in my case I also use a "clear filters" button which is actually a bookmark where the data is displayed with filters by default (so the Bookmark Data property must be active), but using this button removes the URL filter and I have to make a refesh on the page so that the URL filter is applied again. The problem is that if the user clicks on the "clear filters" button, they will be able to see data that they would not be able to see. I shouldn't use the "clear targeting" action as it doesn't work in my context.
As the URL filter is like a report level filter on the whole report (Filter on all pages), you can set up this filter in the report in advance, and lock and hide it. Then create bookmarks on the page. In this way, this filter can always be active and won't be removed by bookmarks.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @v-jingzhang,
I can't set the filter in advance because the parameter differ according to the contexte in our Web based CRM. So I don't know in advance the value of the parameter. I only know the column which will bo filtered on. Is there a way to "store" the filter state at startup and restore it later ... ?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
114 | |
76 | |
57 | |
52 | |
44 |
User | Count |
---|---|
165 | |
116 | |
63 | |
57 | |
50 |