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:

     

OwenAuger's avatar
OwenAuger
Super User
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?

  • asjones's avatar
    asjones
    Helper V
    9 months ago

    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's avatar
      OwenAuger
      Super User
      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: