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
bgrimcos
New Member

Problem with drill-through filtering

I'm working on drill-through reporting and have an issue with filters not applying. 

The easiest way to get everything to work on the drill-through page is to allow "keep all filters". And this works great. However my visual won't display correctly if I do that based upon the way I've set things up. No problem, right? I should be able to pick and choose what filters come through. 

But I simply cannot get one filter to carry over from the higher-level report. I've read other posts here but none seem to duplicate my issue.

 

Below is a shot of the report I want to drill down from. 

 

bgrimcos_0-1723138716250.png

This is filtered several ways but the ones I need to carry through are "study", "measure", and "biz/resi". When you highlight a bar on the chart and choose "drill through" it will take you to the report below.  

bgrimcos_2-1723138844191.png

 

Works as intended, however as mentioned I need to remove several of those filters. Specifically I'm removing "timeframe" and "top 1 translated date". But as soon as I uncheck "keep all filters" and rerun the drill through it will only filter on one item (see below). 

 

bgrimcos_4-1723140750086.png

 

I've tried manually adding these filters back in but they won't stick once I re-run the drill through. Any ideas?

Very new to PowerBI and would love any suggestions.

Here's my relationships:

bgrimcos_5-1723140858019.png

 

 

 

 

2 REPLIES 2
amitchandak
Super User
Super User

@bgrimcos , Not very clear. But once you uncheck, Keep all Filter. All the filter you want to pass need to added to drill through filters 

 

The information you have provided is not making the problem clear to me. Can you please explain with an example.


Power BI Drill Through/selective  Drill Through- More than one level: https://www.youtube.com/watch?v=hCAAvpppQmk

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

Thank you for taking a look at my example. 

Maybe I can restate a little more simply. 

Let's define the page I'm drilling through from as the source page. And the page I'm drilling through to as the drill-through page. 

On the drill-through page I have "keep all filters" set to Off. Only the Measure filter applies.

bgrimcos_0-1723648992619.png

Because I need to filter by Biz/Resi I add that to the drill through filters:

bgrimcos_1-1723649059417.png

Going back to the source page I have Biz/resi set as a filter as you can see here:

bgrimcos_2-1723649267053.png

 

However when I drill through from this page the filter does not apply. 

Here's how the drill-through page filters look after I drill through:

bgrimcos_3-1723649330513.png

 

Note that the Biz/resi is set to (All) even though the page I came from was filtered to "residential".

I'm trying to find a way to get that filter to apply to the drill-through page from the source page.

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.