Forum Discussion
Use Wildcard Operator
| Column |
| BXC1234 |
| BXC77882 |
| ABCGDEE |
| DFGUYSH |
| BXCIUYH |
Suppose I have this column to filter such that I want only values start from BXC. How to achieve in paginated report. I am not using query but using existing semantic model
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.
4 Replies
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 ,
The best way to achieve is via * operator
You can configured the wildcard filter and add expression as your columnnB, operator : like and value: type BXC*🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
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 KumarHi SudhanshuD4512,
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
