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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
ppvinsights
Helper III
Helper III

Conditional Drillthrough - deactivate Drillthrough in Visual

Hi Community,

 

the conditional drillthough functionality is really awesome. Is it possible to deactivate the "context-menu drill through" in a visual?

 

Example:

I have a report with a button for a conditional DrillThrough.

Say I have two bar charts. A user has to select one bar in Chart 1 and another in Chart 2. Only if selected one bar in each of the visuals the button becomes active. No problem.

But: right click on Chart 1 or Chart 2 opens still the "old" Drillthrough... Is there a way to deactivate this DrillThrough in the Visual?

 

The real problem

What I want to achive (the real problem): Using USERPRINCIPALNAME I can introduce a table with user priviledges to control, who is allowed to open the drillthrough page and who is not... This is no problem with the conditional drillthrough button - but if the user is still able to use the "old" drillthrough in the visual, I cannot solve my problem 😞

 

Thanks

Holger

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@ppvinsights To the best of my knowledge there is no way to disable the old drillthrough behavior in a report short of not using drill through all together.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

@ppvinsights To the best of my knowledge there is no way to disable the old drillthrough behavior in a report short of not using drill through all together.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Greg_Deckler
Super User
Super User

@ppvinsights - This sounds more like an row level security problem to me?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Yes and no. I can use RLS to suppress data in the drilldown. But I cannot suppress the drilldown itself. Using the conditional drillthrough I could do it. But only if the "old" way could be dectivated...

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.