Forum Discussion
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
- Greg_DecklerCommunity Champion
Have you tried %20 in your table name, so 'My%20Table'?
- AnonymousNot 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_DecklerCommunity 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?