Forum Discussion

Nixan's avatar
Nixan
Frequent Visitor
2 years ago
Solved

URL Filtering Issue

I have an issue with URL filtering  my page level filter is 'Projects'[Project Name] .  When trying to filter using 

https://app.powerbigov.us/groups/me/apps/86457f37-7f01-4f63-b0ba-f1af369bd6fd/reports/474dc2fb-8489-4bc9-aba5-282b887144cc/ReportSection2c8d5bc914096c1cc668?filter=_x0027Projects__x0027%2F0x005BProject_x0020_Name0x005D%20eq%20%27ATT%20Cloud%27"  

 

would not work. 

 

URL
  • Anonymous's avatar
    Anonymous
    2 years ago

    Your ideas is so great lbendlin 

    Hi, Nixan 

    You can use the following link to put the data in your report where the Project name column of the project table equals Accela GIS.

     

    https://app.powerbigov.us/groups/me/apps/86457f37-7f01-4f63-b0ba-f1af369bd6fd/reports/474dc2fb-8489-4bc9-aba5-282b887144cc/ReportSection2c8d5bc914096c1cc668?filter=Projects/Project%20name eq 'Accela GIS'

     

     As provided by Super User. Since there is a space in your column Project name, we need to use the escape characters provided by the document.

     

    %20

     

     

    Let's take the example PBIX file for Power BI as an example. An example URL for filtering Store Type = New Store is:

     

    https://app.powerbi.com/groups/xxxx/reports/xxx/ReportSection4?filter=Store/Store%20Type eq 'New Store'

     

     

    Best Regards

    Jianpeng Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

3 Replies

  • Nixan's avatar
    Nixan
    Frequent Visitor
    2 years ago

    I tried that but it's not working. Is there anything else I can try.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Your ideas is so great lbendlin 

    Hi, Nixan 

    You can use the following link to put the data in your report where the Project name column of the project table equals Accela GIS.

     

    https://app.powerbigov.us/groups/me/apps/86457f37-7f01-4f63-b0ba-f1af369bd6fd/reports/474dc2fb-8489-4bc9-aba5-282b887144cc/ReportSection2c8d5bc914096c1cc668?filter=Projects/Project%20name eq 'Accela GIS'

     

     As provided by Super User. Since there is a space in your column Project name, we need to use the escape characters provided by the document.

     

    %20

     

     

    Let's take the example PBIX file for Power BI as an example. An example URL for filtering Store Type = New Store is:

     

    https://app.powerbi.com/groups/xxxx/reports/xxx/ReportSection4?filter=Store/Store%20Type eq 'New Store'

     

     

    Best Regards

    Jianpeng Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.