Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
belightwavre
Regular Visitor

URL Filters removed by bookmarks

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

4 REPLIES 4
Syndicate_Admin
Administrator
Administrator

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.

v-jingzhang
Community Support
Community Support

Hi @belightwavre 

 

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. 

vjingzhang_1-1663137158777.png

 

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 ... ?

Hi @belightwavre 

I'm not sure currently. I need to do some test on it. 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.