Forum Discussion
Advanced filters using character ?
Advanced filters using character ?
An example for a filter:
w?s
What will happen as * will be executed as AND statement.
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
5 Replies
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-slicerHi 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
