Forum Discussion

combine_sign's avatar
combine_sign
Regular Visitor
1 year ago
Solved

Advanced Filter in Table not Working

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...
Need Help
  • V-yubandi-msft's avatar
    V-yubandi-msft
    1 year ago

    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.

Naila-Rais's avatar
Naila-Rais
Advocate IV
1 year ago

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?