Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

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.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.