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.

combine_sign's avatar
combine_sign
Regular Visitor
1 year ago

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.