Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter page using query parameter

Hello,

 

i've found this post that shows how to filter a report using query parameters.

 

https://app.powerbi.com/groups/me/reports/8d6e...?filter=Store/TerritoryChain eq 'NC'

Unfortunately, I can't get it to work. I assume that it should also work on hidden pages (drillthrough destinations)?
In addition, my table name does not consist of only one word. I have tried it in several ways, but the filter is never applied:

 

https://app.powerbi.com/groups/34...b2/reports/1d...64f/ReportSection76ad...0b68c?filter='My Table'/ColumId eq 'b5aa0e97-5c8b-4b10-92a7-6f8cfe4f01e2'

What am i doing wrong here? Is there a special syntax or are only "single word"-named tables possible?


Second Question to that topic: Is there away to clear all other page filters using a query string parameter too?

Kind regards,

Holger

 

 

 

 

  • I can't find a way to get that syntax to work with a space in the table name. Can you just rename your table?

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Greg_Deckler wrote:

      Have you tried %20 in your table name, so 'My%20Table'?


      yes.. also the browser also url encodes spaces automatically.. 

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion

        I can't find a way to get that syntax to work with a space in the table name. Can you just rename your table?