How to apply filter and call the another report with same filter conditions

[rajendraongole1]

Hi

have a query with filters. 

i have few columns like country, name,size,orders in two different published reports in power bi services. requirement is if i filter the country , name, size and orders in one report i have bookmarked the another report in same report . but i want to filter the same in another report with same fields.

is there any way to do?

in measure, i have passed the another report link to redirect,. but filter is not happening from same. 

please suggest.

[v-eachen-msft]

Hi @rajendraongole1 ,

I am afraid that you couldn't do it currently. The maximum working range of filter is one report with all its pages, so it cannot work on two different reports.

[rajendraongole1]

Hi

To get the same filtering in another report, workaround i am doing is created a measure in the current report that i am going to filter and calling the measure in bookmark field with another report in action as below but it is working for one filter not for multiple filters.

any suggestions?

text_URL =
Var Link1 = "http://app.powerbi.com"

Var Customer = IF(ISFILTERED(table1[Customer]),
"table2/Customer in ("&"'" & CONCATENATEX(VALUES(table1[Customer]),table1[Customer],"','") &"'"& ")","")
Var x = Link1 & Customer
Return x

[v-eachen-msft]

Hi @rajendraongole1 ,

Yes, you are very close to the result.
You can refer to my measure:

URL =
VAR a = "You current URL"
VAR b =
    IF (
        ISFILTERED ( Table1[Country] ),
        "?filter=Table1/Country in (" & "'"
            & CONCATENATEX ( VALUES ( Table1[Country] ), Table1[Country], "','" ) & "'" & ")"       
    )
VAR x = a & b
RETURN
    x

You need replace my data with yours. If you have multi filters ,you need to use "and" to combine them manually.  

Here is the document you can refer to.

https://docs.microsoft.com/en-us/power-bi/service-url-filters#filter-on-multiple-fields

[rajendraongole1]

Hi

To get the same filtering in another report, workaround i am doing is created a measure in the current report that i am going to filter and calling the measure in bookmark field with another report in action as below but it is working for one filter not for multiple filters.

any suggestions?

text_URL =
Var Link1 = "https://app.powerbi.com/groups/c12121aeb15-xxxxx-vvvvv-yyyy-xxxxxxxxx/reports/"

Var Customer = IF(ISFILTERED(table1[Customer]),
"table2/Customer in ("&"'" & CONCATENATEX(VALUES(table1[Customer]),table1[Customer],"','") &"'"& ")","")
Var x = Link1 & Customer
Return x