powerbivisualizationreportingdashboardbusiness-intelligence

PowerBI remember filters when opening new report from another report


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 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?


Solution

  • 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]
      )