topic Re: Use Wildcard Operator in Report Server

Use Wildcard Operator

SudhanshuD4512 — Wed, 10 Dec 2025 05:57:27 GMT

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

Re: Use Wildcard Operator

123abc — Wed, 10 Dec 2025 06:20:10 GMT

There are many ways to do this, pleaes try following:

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%

Using LEFT Function

1. Add a filter to your dataset or tablix
2. Set the filter expression to:
  text
```
=LEFT(Fields!YourColumnName.Value, 3)
```
3. Set the operator to =
4. Set the value to: BXC

3:

Using InStr Function

For more complex pattern matching:

text

Expression: =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.

Re: Use Wildcard Operator

grazitti_sapna — Thu, 11 Dec 2025 04:49:21 GMT

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!

Re: Use Wildcard Operator

Anonymous — Mon, 15 Dec 2025 02:57:52 GMT

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

Re: Use Wildcard Operator

Anonymous — Fri, 19 Dec 2025 03:35:49 GMT

Hi @SudhanshuD4512,

Best regards,
Prasanna Kumar