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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Lenskie15
New Member

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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