Forum Discussion
Dynamic Filtering not working with new table visualization
I have a dynamic filter on a table that link to a different report. When I changed the table to the new table visual the links go to the correct report but do not filter even though the filter data is passed into the url correctly. Anyone else having this issue? I was able to validate this as the root cause by using an older version of the file with everything else the same except for the visual type was the old static table.
ETA is between 08/16 and 08/21 for Power BI Service.
The fix will appear on Sep 2017 version of Power BI Desktop (Usually first week of September).
A workaround is to replace any space in the data with %20
This can be done using a calculated column as
Url2 = SUBSTITUTE(Table1[URL], " ", "%20")
Best Regards,
Herbert
6 Replies
Hi Mbuczynski,
Could you please provide more information?
What kind of URL and link here? (maybe you are using Power BI embedded.)
Maybe these two posts could help:
Passing-parameters-to-the-report-URL
https://www.youtube.com/watch?v=nfkVljh_9O4&feature=youtu.be
Best Regards!
Dale
v-jiascu-msft - This is on a published report in the power bi service. I used the dynamic filtering technique listed in the guy in a cube video linked below. It was working until I changed the table to the new table format (the one that can be clicked and used as a filter) included with July's release.
Hi Mbuczynski,
There is a workaround for now. Just for now, I am going to submit an report internally and I will post here as soon as I get response.
The workaround is: create the url, then paste it in the browser. Finally we will get a new url. Use this new url in the report.
Thank you for your understanding and patience.
Best Regards!
Dale
