Cross Report Drill Down is a very useful and time saving feature that allows an organization to leverage previous work to enhance and support new reports with additional information and details. To implement this there is a specific requirement that the dataset and colunm names in the SOurce and Target reports match exactly. The reasoning is apparently so that a user can right click on an enabled visual and see other reports/pages portraying the same data and choose which to view.
While this is a laudiable and useful scenario, it requires unrealistic dicipline across an organization and across time to ensure dataset and columns names are standardized. And of course there is no garantee that the Target page will already be named appropriately for the context of the Drill Down process.
I would like to propose an alternative approach (while not affecting the current one):
Allow the developer to link a dataset from the Source Report to the Target Report by specifically identifying the datasets and key columns despite their having different names. Also, this alternative approach should eliminate the requirement for the user to decide which report and page to drill into and instead, select a single, "More Details"option in the Right Click context menu. This would give the developer ultimate control on how the cross report drill down works and eliminate the need for the datasets and column names ot match. Also, Target page names become irrelevant.
With this new approach, the entire library of PBi reports could be made available for Cross Report Drill downs without requiring that dataset and column names match and also eliminate the need to edit older report page names to reflect the context of a new Drill Down Link.
on:
Tasks and Notes Pane in Power BI Desktop with Jira...
lbendlin
on:
Fabric Copy Activity Upsert Needs Native Audit Col...