Url filters Power BI

[Thomas94401]

Hi, 

I'm trying to figure out how the dynamic filter works on a URL.
For example, I created a very simple Power BI desktop with a single table Table1 with 2 columns A and B
I would like to filter on column B = "Raymond" so that he shows me a single row of the table

So I took the url on Power BI services and added the filter https://app.powerbi.com/groups/e72a1ad4-f6bd-4059-a35b-76fe0ad9e720/reports/2e6bd25b-0f4c-41bd-bdeb-... eq 'Raymond'

But it doesn't filter out at all. I don't know what I'm doing wrong? Could you help please?

[Thomas94401]

Is it possible to show me an example of dynamic URL filters? To understand how it works! Im trying to do the same as indicated in https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

But it does not working with me!

[lbendlin]

https://app.powerbi.com/groups/me/reports/xxxx-d214-4b96-830b-1525803763b5/yyyyd9afe8785434cd?experience=power-bi&filter=Table%2FManager_x0020_Name%20eq%20%27Mayank%27

You see that the filter works, however they no longer mark it as italics. That is sad.

That prevents your report user from understanding where a  filter came from.

Also note that Report URL filters are only suggestions.  Users can modify them.

[Thomas94401]

I do exactly the same thing as you! But it doesn't work:(

Could I try with your pbix file?

[lbendlin · Accepted solution]

here you go

[Thomas94401]

Thank you so much.
It works in your file. Can you tell me whats wrong with my file? I am lost ...

[lbendlin]

Can you post your file?

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.


Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

[lbendlin]

looks benign. Make sure your filter is impacting the data model (ie it is applied to a dimension table)

Filter a report using query string parameters in the URL - Power BI | Microsoft Learn

[Thomas94401]

I have only one table. What do you mean?

When I filtered on B, i would like this.

[lbendlin]

If you do that from a URL in the service then the filter is supposed to show in italics, indicating that it comes from outside the page.

If the italics don't show then you used the wrong filter

[Thomas94401]

I'm sorry, I do not understand your answer!