Skip to main content

Power BI

Needs Votes

Drill through Choose the drill throughs you dont want to show

Vote (200) Share
's profile image

on 26 Apr 2019 19:59:21

I have a report with lots of drill throughs and in some cases I'm given more Drill through reports than I would like


For example, I have a top level report and drill through to a region. I then Drill through on another category to a detail report containing all the data (Line By Line). I have a drill through to the one data item from this report. However, bycause region is also in this table I click on a row and can choose my lowest level drill through AND the Region Drill through that I clicked on earlier.


I want the drill throughs to be a little less confusing for the user. Can I stop the region one from appearing here and just show the lowest level drill through without having to get rid of the region column in the table?

Comments (20)
's profile image Profile Picture

Nadiya Pavlov on 30 Oct 2024 13:27:21

RE: Drill through Choose the drill throughs you dont want to show

The current workaround of duplicating columns is not efficient for maintenance. This feature is very much needed

's profile image Profile Picture

Giuliano Santagata on 01 Aug 2024 13:09:57

RE: Drill through Choose the drill throughs you dont want to show

With some work into modeling...this seems to be achievable using RLS features, as clarified in this thread:https://community.fabric.microsoft.com/t5/Desktop/Role-Based-Security-stopping-certain-users-from-accessing-drill/m-p/607336 However, a simpler and more straightforward solution would be very much appreciated.

's profile image Profile Picture

Spiros Papadopoulos on 11 Jan 2024 20:53:36

RE: Drill through Choose the drill throughs you dont want to show

I have a series of Maps for different categories that I need to be able to drill through to specific detail pages, having the ability to restrict to which page a drill-through can go, allows me have a more meaningful navigation through my report

's profile image Profile Picture

Kamal Yadav on 20 Nov 2023 15:58:34

RE: Drill through Choose the drill throughs you dont want to show

We totally need this please! Must be very useful.

's profile image Profile Picture

Bernhard Essletzbichler on 20 Nov 2023 15:57:23

RE: Drill through Choose the drill throughs you dont want to show

Would love to see that - very useful

's profile image Profile Picture

Henni Suokko on 20 Nov 2023 15:41:32

RE: Drill through Choose the drill throughs you dont want to show

This would be very valuable not to have all drill-through pages showing for all visuals

's profile image Profile Picture

Justin Jungbauer on 20 Nov 2023 15:37:12

RE: Drill through Choose the drill throughs you dont want to show

This would be incredibly useful for our reports. We build several drill-throughs for more detail. Often, not all drill-throughs make sense where they are being displayed. Being able to limit where drill-throughs are available would greatly benefit usability and reduce confusion.

's profile image Profile Picture

Nadiya Pavlov on 07 Jul 2023 12:44:08

RE: Drill through Choose the drill throughs you dont want to show

this is very much wanted, but also not just for visuals, but for multiple summary pages to drill through to the same Detail page, but not each other.

's profile image Profile Picture

Alaa Radaideh on 01 Jun 2023 12:48:24

RE: Drill through Choose the drill throughs you dont want to show

Very much wanted

's profile image Profile Picture

Angelo Lissoni on 16 Mar 2023 07:01:00

RE: Drill through Choose the drill throughs you dont want to show

I am absolutely begging for this feature to be implemented.