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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
March Fabric Community Update

Fabric Community Update - March 2024

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

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.