cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
John_de_Kock Frequent Visitor
Frequent Visitor

Clear CURRENT Report filter when passing a filter through the URL (See image in post)

Pic1.PNGHi all, 

 

We have this report that filters on one specific id at a time.

 

Now we want to pass a value to filter on that field from another app. 

 

?filter=Datsetname/Fieldname eq 'value'  is what we add to the url and then get the filter applied. 

 

PROBLEM :

 

Because there is allready a filter applied, we want to , when the filter is passed through the URL, to remove the orriginal one and use this one instead. 

 

So, looking at the image, Keep filter 2, remove filter 1.

 

I cant publish the report without any filter applied due to the amount of data and visualisations im using , it kills the report in terms of speed etc.

 

so i need to publisht he report with a filter allready applied , we just want to pass another value and replace the current one.

 

Hope this makes sense

 

thank you

1 REPLY 1
Community Support Team
Community Support Team

Re: Clear CURRENT Report filter when passing a filter through the URL (See image in post)

Hi @John_de_Kock

 

You may have a look at below document and pay attention to the Considerations and troubleshooting.

 

https://docs.microsoft.com/en-us/power-bi/service-url-filters

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.