Use URL filter to search multiple fields

[DJTentman]

I'm creating a web page that pops up when there is an incoming call to show customer records based on the caller ID. However, I need to search multiple phone number fields. I have several ideas, but I've not been able to make any of them work:

1. Concatenate all phone numbers into one field and use CONTAINS. However, URL filters don't have a CONTAINS function
2. Use OR. "Phone 1" eq 'xxx-xxx-xxxx' OR "Phone 2" eq 'xxx-xxx-xxxx'. However URL filters don't support OR

How could I accomplish something like this?

[DJTentman]

Thanks for the links. However, I did already read those, and they did not help with the issue I described.

[v-yadongf-msft]

Hi @DJTentman ,

You can use URL Filters to provide different report views. For example, the URL below filters the report to show data for the Energy industry.

Using the combination of pageName and URL Filters can be powerful. You can build experiences using basic HTML and JavaScript.

For more information, please refer to: Embed a report in a secure portal or website - Power BI | Microsoft Learn

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.