topic Re: Filter with query string parameters in the URL in DAX Commands and Tips

Filter with query string parameters in the URL

MathieuF — Mon, 02 Oct 2023 15:43:59 GMT

Hello,

I'm having a problem using query string parameters in the URL.
The date filter is fixed relative to the saving of my file.
That is to say, if I publish my file with the filter from 05/01/2023 to 08/31/2023, when users open the report the filter is automatically set to 05/01/2023 to 05/31 08/2023. If I use the filter with a URL query string parameter, I can only filter my dates. If for example I put &filter=Calendrier%2FDate%20ge%202023-06-01T22:00:00.000Z%20and%20Calendrier%2FDate%20le%202023-09-30T22:00:00.000Z I will only have the 01/ 06/2023 to 08/31/2023.
Clearly, the filter via the url does not delete the filter values already entered in the report.

Is there a way to remove the filter saved in the report to make way for the URL filter?

default filter saved in the report

filter by url query:

THANKS

Re: Filter with query string parameters in the URL

lbendlin — Tue, 03 Oct 2023 23:56:04 GMT

1. Make sure you are actually impacting the same table and column.

2. A URL filter is a suggestion. The users can still hit "Reset to Defaults" to get the other filters back.

Re: Filter with query string parameters in the URL

MathieuF — Fri, 20 Oct 2023 07:25:20 GMT

Good morning,
Please forgive me for my late return.
I figured out how to do it. I created a specific tab and I no longer use bookmarks which corrected the problem.
Mathieu