Multiple value drill through question

[gaboya]

Hello! My desktop report consists of a table with names, and by drilling through each name, the user gets moved to the next page, where a paginated report tailored to the selected name appears. How can I enable the user to drill through multiple names at once and get MULTIPLE reports appear, an individual paginated report page for each selected name? Thanks in advance. 

[hackcrr · Accepted solution]

Hi, @gaboya 

Unfortunately, Power BI does not inherently support multi-select drill-downs any more than it supports single-select drill-downs. However, you can work around this limitation by utilizing DAX and bookmarks. Create a DAX metric that concatenates the selected names into a string. This metric will be used to pass the selected name to the paging report.

Create a metric to link selected names:

SelectedNames = 
CONCATENATEX(
    VALUES('YourTable'[Name]),
    'YourTable'[Name],
    ","
)

URL to create a metric to generate a paging report:

PaginatedReportURL = 
"your_paginated_report_url" & "?names=" & [SelectedNames]

Create Bookmarklet: creates a bookmarklet to navigate to the URL generated by the metric. this may involve using a custom button that triggers the navigation action.
Navigation Button: creates a button in the report and sets the action to navigate to the URL. binds the URL action to the metric PaginatedReportURL.

Insert a button in your report. Set the action of the button to "Web URL".
Bind the URL to the degree PaginatedReportURL measure

By using DAX metrics to connect selected names and generate URLs, combined with bookmarks and custom buttons, you can implement multi-select drill-down functionality that generates multiple paged report pages for each selected name. This approach leverages existing Power BI functionality to overcome the limitations of single-select drill-downs.

If this post helps, then please consider Accept it as the solution and kudos to this post to help the other members find it more quickly