[Urgent] Power BI url filtering issue with & and + in value

[wchiu]

Hello, 

well according to Microsoft, 

However, I notice there are issues when the field value is & or + ,,
because I am guessing

Suppose I want to send Customer Age by enquiry date in ('366+') to the url
Power BI will translate as below

Customer_x0020_Age_x0020_by_x0020_Enquiry_x0020_Date%20in%20(%27366%20%27)
+ becomes %20....... 

Also, if  a value that contains & , the link will break...... 
For example, 
I want to pass : Customer in( 'A&B' )
The returned link would become Customer%20in%20(%27A
It stops right at A because & in url means break.
The link will die and return full set of report to user. 

Any creative idea to avoid the problems???

[v-angzheng-msft]

Thank you for sharing😀

Best Regards,
Community Support Team _ Zeon Zheng

[wchiu · Accepted solution]

OK...I found the answer on my own. 
I can use substitue function to replace + or & into unicode.