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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
GVTioluxe
Helper I
Helper I

Conditional Cross Report Drill through

Hi

 

I have a one report of Stock qty , value by Product category and other reports with more drilled down visuals for each product category/ I would to do a conditional cross report drill through to the appropriate report based on the category selected. how should the Dax be written so that the action can be assigned to a button ? i have done this within a report but dont know how to do cross report

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

Hi @GVTioluxe 

 

Currently the drillthrough button doesn't support cross-report drillthrough. You can find this limitation from Create a drillthrough button in Power BI - Power BI | Microsoft Learn

vjingzhang_0-1680758001532.png

You can vote up an idea for this feature at Microsoft Idea: Cross Report Drillthrough via Button

 

As a workaround, you can use the URL filter in button with Web URL action. But this will open the report in a new tab. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

1 REPLY 1
v-jingzhang
Community Support
Community Support

Hi @GVTioluxe 

 

Currently the drillthrough button doesn't support cross-report drillthrough. You can find this limitation from Create a drillthrough button in Power BI - Power BI | Microsoft Learn

vjingzhang_0-1680758001532.png

You can vote up an idea for this feature at Microsoft Idea: Cross Report Drillthrough via Button

 

As a workaround, you can use the URL filter in button with Web URL action. But this will open the report in a new tab. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.