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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Balhemkan
Helper III
Helper III

Drill Through by one click

Hi Team, 

 

Now drill through is available on right click. Can you please tell me how we can make drill through by "one click"or double click. 

But we should not use right click. 

 

Please suggest any work around

 

Thanks,

Balhemkan

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Balhemkan ,

 

Now, You can set up a drill through button,it will be much easier for report consumers to see that they can drill through more details. 

After you added a button to your canvas, there are a few properties you need to set in order to get this working. 

  • Type of action, set this to Drill Through (Preview)
  • Destination, select the page you want the button to navigate to. 
  • Enabled tooltip (optional): Hover over text if the button is enabled.
  • Disabled tooltip (optional): Hover over text if the button is disabled. 

By default, the button is grayed-out, until you select an item in one of the other visuals. Based upon your selection, the button will be activated. My advice is to use the textual tooltips, so you can easily inform your report consumers what they need to do in order to activate the button. 

 

To set up a drill through button, you will first need to have valid drill through page within your report. Then, you will need to create a button with Drill through as the action type and select the drill through page as the Destination.

For more information, please see:Power BI Desktop March 2020 Feature Summary 

 

Hope it helps,


Community Support Team _ Caitlyn

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

 

 

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi @Balhemkan ,

 

Now, You can set up a drill through button,it will be much easier for report consumers to see that they can drill through more details. 

After you added a button to your canvas, there are a few properties you need to set in order to get this working. 

  • Type of action, set this to Drill Through (Preview)
  • Destination, select the page you want the button to navigate to. 
  • Enabled tooltip (optional): Hover over text if the button is enabled.
  • Disabled tooltip (optional): Hover over text if the button is disabled. 

By default, the button is grayed-out, until you select an item in one of the other visuals. Based upon your selection, the button will be activated. My advice is to use the textual tooltips, so you can easily inform your report consumers what they need to do in order to activate the button. 

 

To set up a drill through button, you will first need to have valid drill through page within your report. Then, you will need to create a button with Drill through as the action type and select the drill through page as the Destination.

For more information, please see:Power BI Desktop March 2020 Feature Summary 

 

Hope it helps,


Community Support Team _ Caitlyn

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

 

 

mahoneypat
Microsoft Employee
Microsoft Employee

Are you taking advantage of the new feature a few months ago to have Drilldown and Drillthrough available on hover for your visuals?  In that case, it becomes a single click.

Power BI Drill Through and Drill Down Must Know Game Changer - YouTube

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Hi,

Is this option available to setp for the Visuals except Table or matrix? Beacuse i have tried enabling the feature, drillthough option directly comes for bar chart but not for the tabular view.

 

Thanks

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 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.

Top Solution Authors