Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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?
Have you tried %20 in your table name, so 'My%20Table'?
@Greg_Deckler wrote:Have you tried %20 in your table name, so 'My%20Table'?
yes.. also the browser also url encodes spaces automatically..
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?
@Greg_Deckler wrote: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?
Yes, that is what I have done now, but was not my desired solution.
If the multiword tables in the service are valid, it should be documented that this kind of table name syntax is not supported for the query paramater.
Thanks for your answers Greg,
Holger
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.