Conditional Cross Report Drill through

[GVTioluxe]

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

[v-jingzhang · Accepted solution]

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

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.