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
djbuncle
Helper I
Helper I

Limit drill-through report options

Hi. 

I was just wondering whether there's a way to limit which drill-through reports are available when right-clicking on a particular visual (to select the report). The issue is that I have serveral drill-through pages in a report, however some don't actually make sense for the user to drill through-to from a particular visual, yet they still show as an option.

 

Thanks.

4 REPLIES 4
MicahDF
Frequent Visitor

One possible work-around for this is to create duplicates of the fields that are used for the drill-through filters and then only use those fields in a particular context.

 

For example, let's say you have drill-throughs for an "Expense" report and a "Revenue" report that are based off the account name, but you only want to show the Expense drill-through on your Expense summary visual and you only want to show the Revenue drill-through on your Revenue summary visual. To get that behavior create duplicates of your account name and call one "Account_Name_Expense" and the other "Account_Name_Revenue". Only use Account_Name_Expense in your expense drill-through and visuals and only use Account_Name_Revenue in your revenue drill-through and visuals. To users the displays show the identical account names, but the drill through options will be different.

 

This is still just a workaround and I encourage people to vote for the suggestion to make a proper drill-through control.

v-xicai
Community Support
Community Support

Hi @djbuncle ,

 

Your demand is a good idea, while there is no such way to limit drill-through report options in Power BI currently. You can post your new idea in Idea Forum , add your comments there to improve Power BI and make this feature coming sooner. As a workaround, you may deleted the extra drill through pages.

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I see someone has recommended this feature as well, so I'll up-vote him!

For others looking to vote, go here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/37479514-drill-through-choose-the...

link is not opening, if this was implemented?

 

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.