PowerBI remember filters when opening new report from another report

Question

We are building a new dataplatform. In this platform we want to create multiple new dashboards. The first few dashboards have aggregated information; the other reports contain all the details.

The structure is as follows:

• report 1 has aggregated information
• report 1a has all the details concerning the data in report 1

Report 1 is placed in workspace A, report 1a is placed in workspace B.

Currently we are able to click on the number and that it opens report 1a in another tab; however it does not remember the filters we used in report 1.

Now we want to have the following function: When i click on a number in report 1, i want powerbi to open report 1a in a new tab but remembering the filters i used in report 1.

Are there any solutions for this inconvenience?

Answer 1

You have two options:

1. If both reports are in the same workspace or app, then you can use Use cross-report drillthrough in Power BI.
2. If reports are in different workspaces, then you can look at using URL Filtering Filter a report using query string parameters in the URL. This option will offer the most flexibility but will require a little more work and maintenance.

For option 2 - You would create a Measure and ensure its Data category is set to Web URL. The measure will need to check and see which filters/slicers are set, and then build the URL with the filters. For example:

// set this to the URL of the report WITHOUT any URL filters
Link report 1a base = "https://....."

Link report = 
  IF ( ISFILTERED(slicerTable[slicerColumn]),

    [Link report 1a base] & 
    "&$filter=Table/Column in ('" &
    CONCATENATEX( DISTINCT(slicerTable[slicerColumn]), [slicerColumn], "','") &
    "')"

    ,

    [Link report 1a base]
  )