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.

maruthisp's avatar
maruthisp
Icon for Super User rankSuper User
1 year ago

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