Advanced filters using character ?

[toplisek]

Advanced filters using character ?

An example for a filter:

w?s

What will happen as * will be executed as AND statement.

[v-tejrama · Accepted solution]

Hi @toplisek,

Thanks for reaching out to the Microsoft fabric community forum.

Yes, I tried this in Power BI using the Text Filter visual (from marketplace), and it works properly with * and ? characters. If you type w*s, it will show words like wins, wires, walks, etc. That means it is picking anything starting with “w” and ending with “s” whatever is there in between, it will match. Same way, if you type w?s, it will give you only 3-letter words like was, wis, whs, where the first letter is “w”, last is “s”, and only one character in the middle. Just to clarify, * is not used as an AND logic here, it simply means “any characters in between”.

This kind of filtering works only in the Text Filter slicer, not in the normal slicer.

I checked this on my side and it's working fine.

Let me know if you need example data or PBIX also.

Best Regards,
Tejaswi.
Community Support

[v-tejrama]

Hi  @toplisek ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. 

Thank you.

[v-tejrama]

Hi @toplisek ,

I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

Thank you.

[v-tejrama]

Hi @toplisek ,

Just checking in have you been able to resolve this issue? If so, it would be greatly appreciated if you could mark the most helpful reply accordingly. This helps other community members quickly find relevant solutions.

Thank you.

[MFelix]

Hi @toplisek ,

To do advance filtering based on characters you can try the new text slicer that allows these kind of filtering.

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-text-slicer