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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Lenskie15
Regular Visitor

Drill Through Buttons with filtered Data

Hello PowerBI Community!

I have buttons set up to navigate through pages, but I want them to trigger a drill-through action. Specifically, when I filter data using a slicer, I want the button to dynamically change its value based on the filtered result. For example, if the total value is initially 10 and I apply a filter to show only specific data with a value of 3, I want the button to reflect this change. When I click the button, I want it to drill through to a table displaying only the 3 filtered data points, rather than showing all 10.

Has anyone implemented this functionality before? Any guidance or examples would be greatly appreciated. Thank you!

 

2 REPLIES 2
v-yohua-msft
Community Support
Community Support

Hi, @Lenskie15 

 

You can set up an effective drillthrough page in the report.Create a button and set its action type to Drillthrough. Select the drillthrough page as the target.You can pass filters for more fields by cross-filtering the visual that contains the drillthrough field.If your selection is unclear, the button will be disabled.You can customize the formatting options for the disabled status of the drillthrough button.


Keep in mind that the drillthrough button isn't bound to a single visual. It is designed to improve the discoverability of important drillthrough scenarios in your report, and you can also display different text on the button if certain conditions are met.

 

For a more detailed description, you can refer to the following documents:

 

Set up drillthrough in Power BI reports - Power BI | Microsoft Learn

 

Create a drillthrough button in Power BI - Power BI | Microsoft Learn

 

Create buttons in Power BI reports - Power BI | Microsoft Learn

 

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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

 

datawailor
Advocate II
Advocate II

Looks like this video may help with that.
https://bielite.com/blog/dynamic-button-text-web-url/

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.