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

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