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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
indyb
Helper III
Helper III

Drill through adding additional filters

Hi all, 

 

I am creating a page which shows the following : 

 

Employee NameDepartment No of High Rated ErrorsNo of Low Rated Errors
John SmithHR42
Michael JacksonSales31

 

The "No of High Rated Errors" and "No of Low Rated Errors" are both CALCULATE(COUNT( measures.

 

From this I have created a Drill Down Page which shows me the same table as above, but also another table as below : 

 

Error TypeFlag High ErrorFlag Low Error
Error Type 1Yes 
Error Type 2 Yes

 

I am trying to create the drill down to show that when I select a individual on the first page, drill down by that employee name only to the drilldown page, allowing me to see the "Error Type" and if either "Flag High Error" or "Flag Low Error" is applicable.

 

Unfortunately at the moment, the drilldown also applies other filters on the drilldown page such as the "No. of High Rated Errors" = 4, which removes the other "Error Types" when drilling through. 

 

Is it possible to have the drilldown to only have the "Employee Name" Filter when drilling down from the first table?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@indyb , Hope you are talking of drill through

In the drill through you have an option to add drill through the field here. You can remove the filter which you do not want to pass

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@indyb , Hope you are talking of drill through

In the drill through you have an option to add drill through the field here. You can remove the filter which you do not want to pass

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thanks for the link - it showed what i was looking for. 

 

Essentially i needed the "Keep All Filters" toggle set to "off" which sorted my issue! 

 

Thank you!

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.