Is it - somewhow - possible to "forward your filter-settings" to another report?

[Tontaube2]

Hi,

is it somehow possible to forward your filter-settings to reports in Report Server?

I guess this falls under "cross report-drillthrough" - which is not available "by default" (https://learn.microsoft.com/en-us/power-bi/report-server/compare-report-server-service) - but maybe there is a clever way to circumvent this?

Bye

Michael

[Poojara_D12 · Accepted solution]

Hi @Tontaube2 

While Report Server doesn't offer direct, built-in cross-report drill-through to automatically forward filter settings, there are workarounds to achieve a similar effect. One approach involves carefully crafting URLs with parameters that represent the filter values. You would create links in your source report that point to the target report, appending the filter values as URL parameters. The target report would then need to be designed to read these URL parameters and apply them as filters upon loading. This requires a good understanding of how Report Server handles URL parameters and how to implement filtering within your reports. Another option, if the data sources are accessible, is to design the reports to share a common set of parameters or a linked dataset. This way, filter selections in one report could indirectly influence the data retrieved by the second report. However, this approach requires careful planning of the data model and report design. While not a simple "out-of-the-box" feature, these techniques can enable a form of cross-report filter propagation in Report Server.

[v-yohua-msft]

Hi, @Tontaube2 

In Power BI Report Server, there are limitations to implementing drillthrough across reports directly, but there are a few workarounds you can do to achieve a similar effect. You can pass filter settings to another report via URL parameters. In the first report, generate a URL that contains the filter parameters. Embed the URL in an action in the report, such as a button or text box. When the user clicks on the action, they are taken to the second report and the appropriate filter is applied. You can check the following link:

Pass a report parameter within a URL for a Power BI paginated report - Power BI | Microsoft Learn

Or use bookmarks and navigation, which you can use in the same report to simulate drillthrough across reports. While this isn't true cross-report drillthrough, you can implement similar functionality in a single report.

Create report bookmarks in Power BI - Power BI | Microsoft Learn

If you have a Power BI Service, you might consider publishing your reports to Power BI Service to take advantage of its more powerful cross-report drillthrough capabilities. While this requires an additional subscription fee, it offers richer interactive features. You can check this link:

Use cross-report drillthrough in Power BI Desktop - Power BI | Microsoft Learn

You can also set up report subscriptions to email filtered reports to users. While this is not a real-time interaction, it can meet the needs to some extent. You can check the following document:

Email subscriptions for reports and dashboards in the Power BI service - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

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