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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
tstackhouse
Helper III
Helper III

Visual Ignoring Advanced Filtering

I have a visual as shown below. I am attempting to use advanced filtering to get rid of any invoices with the prefix of INMAR and DS. As one can see, it does not seem to be filtering out the INMAR invoices (it is not filtering out DS invoices either but I couldnt include them both on this screen shot). I have used Advanced filtering with sucess before, I cannot seem to figure out why it is not working.

 

Thanks in advance!

 

Advanced Filtering.PNG

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hey @tstackhouse

 

You need to switch the OR to AND. OR won't filter out either because INMAR does not start with DS and DS does not start with INMAR. Kind of confusing...

 

Hope this helps,

Parker

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hey @tstackhouse

 

You need to switch the OR to AND. OR won't filter out either because INMAR does not start with DS and DS does not start with INMAR. Kind of confusing...

 

Hope this helps,

Parker

That is a little confusing. But thank you I will keep this in mind!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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