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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
Niels_T
Post Patron
Post Patron

How to decide which filter will be applied on the drill-through?

In my report I have an overview of all items being sold in a table.

 

In the table I have the folowing column:

 

Brand, Product group, Item, Margin, Margin %, Amount

image.png

 

When I drill-through in my table on a specific product it will bring me to the specific drill-through page but with the following filters:

 

image.png

 

As you can see it applies the filter "Margin". How can I turn it off that it won't take the "Margin" filter in my report?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Niels_T ,  At page level, you have the option to keep all filters. Uncheck that. And then drag the filter to"add drill through filter here" and try

 

drillthrough_02

Share with Power BI Enthusiasts: 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

1 REPLY 1
amitchandak
Super User
Super User

@Niels_T ,  At page level, you have the option to keep all filters. Uncheck that. And then drag the filter to"add drill through filter here" and try

 

drillthrough_02

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

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.