Forum Discussion
Use Wildcard Operator
- 8 months ago
There are many ways to do this, pleaes try following:
1:
Using LIKE with Wildcards
Add a filter to your dataset or tablix
Set the filter expression to your column name
Set the operator to like
Set the value to: BXC%
Expression: [YourColumnName] Operator: Like Value: BXC%
2:
Using LEFT Function
Add a filter to your dataset or tablix
Set the filter expression to:
text=LEFT(Fields!YourColumnName.Value, 3)
Set the operator to =
Set the value to: BXC
3:
Using InStr Function
For more complex pattern matching:
textExpression: =InStr(Fields!YourColumnName.Value, "BXC") Operator: = Value: 1
This ensures "BXC" appears at the beginning (position 1).
Steps to Implement:
Right-click on your dataset/tablix → Properties
Go to the Filters tab
Click Add
Configure the filter using one of the methods above
Click OK
The wildcard % in the LIKE operator matches any sequence of characters, so BXC% will match:
✅ BXC1234
✅ BXC77882
✅ BXCIUYH
❌ ABCGDEE (doesn't start with BXC)
❌ DFGUYSH (doesn't start with BXC)
Note: The exact filter dialog may vary slightly depending on whether you're filtering at the dataset level or the tablix level, but the expression syntax remains the same.
Hi SudhanshuD4512,
Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to grazitti_sapna and 123abc for prompt and helpful responses.
Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna Kumar