Forum Discussion
Third level filters stopped working
My report filters by department, section and supervisors name. When you click on the supervisors name, only their employees should show up. That level of the filter is not working either on the server or in edit mode. Has something with the filters changed? My data has not changed.
Hi Anonymous ,
According to your problem description, when you click on a supervisor's name, only their employees should be displayed. The filters at this level do not work on the server or in edit mode, and based on my research and experience, there are several things that can cause you this problem.
1. First you have to check whether the fields "Supervisor Name" and "Employee" come from the same table, and if not, do they come from two tables with the correct data filtering direction relationship?
2. If it is OK, you also need to make sure that you are using the slicer on top of the report page? If so, you need to check if the interaction is enabled between several visuals containing the fields "Supervisor Name" and "Employee", according to this official document
Change how visuals interact in a report - Power BI | Microsoft Learn
3. If you are using the filter, as far as I know the filter is divided into three levels in the PBI report, and the levels are filtered from top to bottom, you need to make sure that the filter of "Supervisor's Name" is covering the field of "Employee", so as to You need to make sure that the "Supervisor Name" filter covers the "Employee" field so that the filtering is completely correct and valid.
Types of filters in Power BI reports - Power BI | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Anonymous ,
According to your problem description, when you click on a supervisor's name, only their employees should be displayed. The filters at this level do not work on the server or in edit mode, and based on my research and experience, there are several things that can cause you this problem.
1. First you have to check whether the fields "Supervisor Name" and "Employee" come from the same table, and if not, do they come from two tables with the correct data filtering direction relationship?
2. If it is OK, you also need to make sure that you are using the slicer on top of the report page? If so, you need to check if the interaction is enabled between several visuals containing the fields "Supervisor Name" and "Employee", according to this official document
Change how visuals interact in a report - Power BI | Microsoft Learn
3. If you are using the filter, as far as I know the filter is divided into three levels in the PBI report, and the levels are filtered from top to bottom, you need to make sure that the filter of "Supervisor's Name" is covering the field of "Employee", so as to You need to make sure that the "Supervisor Name" filter covers the "Employee" field so that the filtering is completely correct and valid.
Types of filters in Power BI reports - Power BI | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.