Advanced Filter in Table not Working

[combine_sign]

Hello, 

I have loaded two Excel files in Power BI from Payroll and HRIS system. I have transform the data in Power Query, and create a relationship. 

I am trying to filtered my column so I don't see Terminated/Pay Continuance Employees but the filter is not working. If I Filter by selecting only the category I want (for example: Working, On Leave, etc.), it is working perfectly but the Advanced Filtering option doesn't work. I have tried to find the solution for a solid hour but I am desperate now 😭

For a bit more of context: all columns are from the same report. Workday Report To column is a formula using RELATED. Manager Filter is also a formula to compare Avanti and Workday managers.

Let me know if you need additional info! Thanks

[combine_sign]

Thank you all for your insight! It was really helpful! 

I ended up applying the filter in the page instead of the visual, and it worked. I will go with this solution since I would like to avoid creating new columns/mesures.

[V-yubandi-msft · Accepted solution]

Hi @combine_sign ,

Thank you for engaging with the Microsoft Fabric Community.  I reproduced the problem using two sample Excel files (Payroll and HRIS), created relationships, and used RELATED() in one of the columns.

Then, I used this new column (CleanStatus) in the visual level filter with.

1. is not   TERMINATED
2. is not  PAY CONTINUANCE

The filter worked perfectly and excluded the correct rows.

FYI:

Thank you for your inputs @maruthisp & @Naila-Rais .

I’ve attached the .pbix  file for reference. Please take a look  happy to provide more details if needed.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[maruthisp]

Hi combine_sign,

As per your post, I would suggest to debug what could be the issue first. Try below places to look for:

1. Data Type Mismatch - Advanced filters are sensitive to data types.
2. Whitespace or Hidden Characters - Sometimes values like "Terminated " won’t match "Terminated".
3. Case Sensitivity - Advanced filters are case-sensitive.
4. RELATED Function in Use - If the column you're filtering is calculated using RELATED, it might not behave like a native column.
5. Filter Context Conflicts - If you have slicers or page level filters, they might override or conflict with your advanced filter.
6. Advanced Filter Syntax - When using “does not contain” or “does not equal” make sure the logic is correct.

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

Best Regards, 

Maruthi 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X

[Naila-Rais]

The most common reason advanced filtering doesn't work while basic selection filtering does is due to:

1. Data type mismatch: Ensure your status column (Terminated/Pay Continuance) has consistent data types.

2. Try this immediate fix:

   • Go to Power Query Editor

   • Select your status column

   • Right-click → Replace Values

   • Replace any hidden special characters or extra spaces in your status values

3. Alternative solution:

   Filtered View = 
   FILTER(
       YourTable,
       NOT(YourTable[Status] IN {"Terminated", "Pay Continuance"})
   )

If this doesn't work, please confirm:

• Are you using the filter pane or visual-level filters?

• Does your RELATED formula maintain filter context properly?