Forum Discussion

FrankvanDorp's avatar
FrankvanDorp
Helper I
2 years ago
Solved

How to make PowerBI look for a partial string in a Text Filter with user input

I have an app containing data about specific web pages. I want to allow users of this app to paste the URL of a page into a text filter to get data specific to that URL.

However, there are often extra parameters in URLs that make them longer, meaning they are no longer exactly the same as the URLs in the list I'm checking against. So I want the text filter to use regular expressions to look at only part of the URL, and cut off any extra parameters at the end.

So suppose this is the app:

This is how the filter works when searching on "example.com/page1", a literal match with one of the cells:

But it doesn't work on URLs with parameters added, like "example.com/page1&referrer=mail":

Is there a way to make PowerBI look at only part of the string in a Text Filter with user input?

 

Thanks in advance.

1 Reply