Forum Discussion

asjones's avatar
asjones
Helper V
9 months ago
Solved

UR Filtering Not Working

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 ...
Need Help
  • OwenAuger's avatar
    OwenAuger
    9 months ago

    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?

  • OwenAuger's avatar
    OwenAuger
    9 months ago

    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:

     

asjones's avatar
asjones
Helper V
9 months ago

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