Forum Discussion
Advanced Filter in Table not Working
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.
- is not TERMINATED
- 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.
Community SupportHi 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.
- is not TERMINATED
- 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.