Forum Discussion
Dynamic Filtering not working with new table visualization
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
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
v-jiascu-msft - Thank you for the response Dale, and thank you for escalting to the team.
Unfortunately, that work around will not work for us. We have a dynamic set of data that we are using to pass through to the filter and I cannot manually update that each day. At this time the links will remain broken.
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,
Herbertv-haibl-msft - Excellent. Thank you for your help. Looking forward to the fix. In the meantime, the workaround provided works great.