Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sujatakaran
Helper I
Helper I

Filter based on certain text

Hello,

 

I am trying to create a report that should have exclude and include button to exclude/include email ids from certain domains. For example: I have a table that has a list of email ids from various domains, including my company's domain. So, when i click on exclude button it should exclude all internal email ids and filter all the visual to give data for external ids only. and when i click on include button then it should have all the visuals containing all the ids.

 

BR

Sujata

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@sujatakaran , for include and include might need have table(using enter table) or some other way .

 

Include is the default behavior, for exclude refer to this solution. Switch the measure on including an exclude

https://community.powerbi.com/t5/Desktop/Exclude-value-via-a-slicer/td-p/467691

 

Create a slicer for include and exclude / switch measure slicer

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

 

make them look lik button https://docs.microsoft.com/en-us/power-bi/power-bi-slicer-filter-responsive

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@sujatakaran , for include and include might need have table(using enter table) or some other way .

 

Include is the default behavior, for exclude refer to this solution. Switch the measure on including an exclude

https://community.powerbi.com/t5/Desktop/Exclude-value-via-a-slicer/td-p/467691

 

Create a slicer for include and exclude / switch measure slicer

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

 

make them look lik button https://docs.microsoft.com/en-us/power-bi/power-bi-slicer-filter-responsive

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.