Forum Discussion
Drill Through function and What-If Parameter
Hi the Community,
I just transfered from Tableau to Power BI, and currently encountering a problem with what-if parameters and drill through function.
The problem: There is a 2-page dashboard, one summary page and one detail page.
There is a matrix table on the summary page, and what-if parameters are both applied to row and column to enable users to do ad-hoc dimension changing. Moreover, a drill through function is required on matrix table, so that users can easily click on the data point in the table and drill down to the detail page. However, the drill through function is disabled with what-if parameters.
The research studied:
I noticed that this problem has been discussed and there is an official page saying that drill through function is not available with what-if parameters. Is there any suggested work around in my scenario?
https://community.fabric.microsoft.com/t5/Issues/Fix-Field-Parameter-drillthrough/idi-p/2534003
*The method tried:
I tried to make the summary and detail on the same page, and thought bookmark and filter interaction among visuals might work as a drill through function. However, filter interaction does not work with visual objects in different bookmarks.
(refrence site: https://community.fabric.microsoft.com/t5/Desktop/Cross-filtering-and-bookmarks/td-p/2174503)
Thanks in advance!
Best regards,
Wendy