Forum Discussion

Mbuczynski's avatar
Mbuczynski
Frequent Visitor
9 years ago
Solved

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 i...
General Comment
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    Mbuczynski

     

    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-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

Mbuczynski

 

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

Mbuczynski's avatar
Mbuczynski
Frequent Visitor
9 years ago

v-haibl-msft - Excellent. Thank you for your help. Looking forward to the fix. In the meantime, the workaround provided works great.