UR Filtering Not Working

[asjones]

I have a Power BI Report published in the service. The page already has a slicer on "Main Project #". I wanted be able to also pass the "Main Project #" as a URL Filter so that I could pick what was the default item loaded. However I can't seem to get the filter to work. It seems to just ignore the filter.

Based on the documetation and searching I have tried the follwingat the end of the Workspace Report URL

?filter=Projects_dim/Main Project # eq 'BD2016'
?filter=Projects_dim/Main_x0020_Project_x0020_# eq 'BD2016'
?filter=Projects_dim/Main%20Project%20%23 eq 'BD2016'
?filter=Projects_dim/Main_x0020_Project_x0020_%23 eq 'BD2016'

None work.

I think I have followed all the steps here

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

along with severl searches and asking ChatGTP.

I then tried a more simple field called "Area" and it did not seem to filter either. 

However the same slicer does just fine.

What am I missing?

thanks

Alan

[OwenAuger · Accepted solution]

Hi @asjones 

The below filter parameter should work with # encoded as _x0023_ (just tested successfully myself):

?filter=Projects_Dim/Main_x0020_Project_x0020__x0023_ eq 'BD2016'

Does this work for you?

[asjones]

I marked your first response as an accepted solution not sure if can make both or not to give you "double" credit.

[asjones]

@OwenAuger 

Thank you for your reply... i did some digging and found the issue. Both of your examples worked except you had the table name with a capital "D" for dim when it was lower case and I did not catch that in the first response and it took me a while after playing with your second response..... i had just copy an pasted. My orignal had lower case "dim", totally understand the confusion. If it had been my data and process I wold have capaltized it lke you did.

So both of these below actualy worked. I truly apprecate your help and digging into this.

Alan

?filter=Projects_Dim/Main_x0020_Project_x0020__x0023_ eq 'BD2016'

filter=Projects_Dim%2FMain_x0020_Project_x0020__x0023_%20eq%20%27BD2016%27

[OwenAuger · Accepted solution]

Hi @asjones 

The below filter parameter should work with # encoded as _x0023_ (just tested successfully myself):

?filter=Projects_Dim/Main_x0020_Project_x0020__x0023_ eq 'BD2016'

Does this work for you?

[asjones]

HI @OwenAuger 

Thanks for the reply.  
Unfortunlay it still did not work. I am really sumped
I tried both Edge and Firefox and neither worked. 

I have a slicer for "Main Project #" but it still defaults to "All"

Is there something that could be funny with the report or is there a system setting that could have accidently ben turned on/off?

As a side note
Edge converted the URL string to
?experience=power-bi&filter=Projects_Dim%2FMain_x0020_Project_x0020__x0023_%20eq%20%27BD2016%27
Firefox did this
?experience=power-bi&filter=Projects_Dim%2FMain_x0020_Project_x0020__x0023_ eq 'BD2016'

[OwenAuger · Accepted solution]

Hi @asjones 

Firstly, the browser encoding the URL with "percent-codes" in the address bar is fine. Mine also converts the filter parameter to

filter=Projects_Dim%2FMain_x0020_Project_x0020__x0023_%20eq%20%27BD2016%27

When a URL filter is applied, a report-level filter (aka "filter on all pages") is created that is visible in the filter pane. However this filter will not make slicer selections (though it may limit values visible in slicers).

If you ensure the filter pane is visible you can verify if it's been applied correctly.

Here's how it looks for me: