Advanced filters

If you only want to filter in a visual, do this:

Steps

1. Select the visual.

2. Go to the Filters pane → find your Email Address field.

3. Change filter type to Advanced filtering.

4. Add these three conditions:

Hi,

You can also build a Column to filter them out and this would be simpler way for maintenance in future. 

If you have email column then simply 

Select Email and then go to advance filtering 
select email starts with 
no-email,

does not begin with   no-email

AND

does not begin with   gmail

AND

does not begin with   sbcglobal

gmail
sbcglobal

Use Advanced filtering on your Email column and stack three “does not start with” conditions combined with AND.​​

Setup:

1. Put Email field in the Filters pane (visual, page, or report level).​

2. Choose Advanced filtering.

3. Add three rules:

   • “does not start with” → no-email

   • “does not start with” → gmail

   • “does not start with” → sbcglobal

4. Make sure the logical operator between them is AND

Hi Del235 

> Option 1: Advanced Filter (Recommended – No DAX)

Select your Table / Visual

Go to the Filters pane

Drag the Email Address column into Filters on this visual

Change filter type to Advanced filtering

Set conditions as:

Show items when value:
does not start with no-email
AND
does not start with gmail
AND
does not start with sbcglobal

📌Make sure you use AND, not OR
📌This keeps only emails that do not start with those values

✔ Example:

[email protected]
[email protected]

x Example removed:
[email protected]
[email protected]
[email protected]

> Option 2: DAX Calculated Column (More Control)

Use this if you want the logic reusable across visuals.

Valid Email =
IF (
LEFT ( LOWER ( Table[Email] ), 8 ) = "no-email"
|| LEFT ( LOWER ( Table[Email] ), 5 ) = "gmail"
|| LEFT ( LOWER ( Table[Email] ), 9 ) = "sbcglobal",
"Exclude",
"Include"
)

Then filter:

Valid Email = Include

> Option 3: Power Query (Best for Large Datasets)

Open Transform Data

Select Email column

Filter → Text Filters → Does Not Begin With

Apply three filters:

does not begin with no-email

does not begin with gmail

does not begin with sbcglobal

Power Query is best for performance and data cleansing

Please give headsup / mark it as a solution once it is comepleted. Thank You!

Hi Del235 ,

This can be done cleanly in Power BI, and the best approach depends on whether you want it at data-load time or report-interaction time.

✅ Recommended approach (Power Query – best practice)

If these emails should always be excluded, do this in Power Query.

Steps

Open Transform data

Select the column with the email addresses

Go to Home → Filter → Text Filters → Does Not Begin With

Add the following conditions:

does not begin with no-email

does not begin with gmail

does not begin with sbcglobal

Combine them using AND

This permanently removes those records from the model.

Equivalent M code
= Table.SelectRows(
Source,
each not (
Text.StartsWith([Email], "no-email")
or Text.StartsWith([Email], "gmail")
or Text.StartsWith([Email], "sbcglobal")
)
)

🔁 Alternative: Advanced Filter in the report (no data removal)

If you want to keep the data but filter it visually:

Select the visual

Go to the Filters pane

Add the Email field

Choose Advanced filtering

Configure:

does not begin with no-email

AND does not begin with gmail

AND does not begin with sbcglobal

This affects only the visual or page, not the dataset.

❌ What not to do

Avoid using CONTAINS or SEARCH for this case

Avoid creating calculated columns unless absolutely necessary

Don’t rely on slicers for exclusion logic like this

Conceptual illustration
Email List
├── [email protected] ❌ filtered out
├── [email protected] ❌ filtered out
├── sbcglobal_user@... ❌ filtered out
└── [email protected] ✅ kept

Summary

✔ Use Power Query if the rule is permanent
✔ Use Advanced Filters if it’s report-level logic
✔ Use Does Not Begin With + AND conditions

If this helped, please consider giving a kudos 👍
And if it solved your problem, feel free to mark this as the Accepted Answer ✔

Hi Del235 

Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.

Del235 Hey,

 Visual-level filter: applies to one visual
- Page-level filter: applies to all visuals on the page
- Report-level filter: applies to the entire report

Steps
1) Drag your Email field into the Filters pane (at the desired scope).
2) Change the filter type to Advanced filtering.
3) Set the condition group to And.
4) Add these clauses:
- does not start with → no-email
- does not start with → gmail
- does not start with → sbcglobal
5) (Optional) Add is not blank to exclude blanks.

Notes and tips

• The text match is case-insensitive. If you have leading spaces in the data, trim them in Power Query (Transform > Format > Trim/Clean).
• If what you actually mean is to exclude Gmail/SBCGlobal by domain, use:

- does not end with → @gmail.com
- does not end with → @sbcglobal.net
or use does not contain with those domain endings.

This will filter out any email addresses that begin with those strings (or those domains, if you use the alternative).

Thanks

Haish K 

If I resolve your issue. Kindly give kudos to this post and accept it as a solution so other can refer this.