Hello,
I’m working on a Power BI visual where I need to filter data based on user input that follows a pattern with wildcard search. Essentially, I want the search function to allow for a dynamic filter where, if there is no * at the end, it should end with the value that was searched for. For example, if the user searches for 'text1*text2', the result should return all values that start with "text1" and that end with "text2". If user searches for 'text1*text2*', there is a * at the end, so the operator is 'contains'. Same for searches with 'text1*'.
Here’s my current setup:
- I’m using the 'contains' operator for filtering, as 'endswith' is not available in the advanced filter API.
- My current logic works for:
- text*: It returns all values that contain the specified prefix before the wildcard with operator 'contains'.
- text: It returns an exact match using the 'is' operator.
However, for searches like text1*text2, I need the filter to behave as if it uses a 'endswith' operator for the part after the *, when there is no * at the end.
Any help is appreciated. Thanks in advance!
