Dynamic Links to other report

[Anonymous]

Hi, 

I have 2 reports and i want one of the reports create a dynamic link to the second report.

For example: i want to select some filters and slicers one of the reports, and click on dynamic link and i will go to other report with same filters inserted, it's possible?

I try this (example) 

VAR year =
    SELECTEDVALUE('calendar'[Year])
RETURN
IF(HASONEFILTER(LINK[Key colummKEY ]),VALUE([URL),year)

Thanks for your attention and regards. 

[v-yuezhe-msft]

@Anonymous,

Could you please share sample data of your table and post expected URL format here?

Regards,
Lydia

[Anonymous]

Hi, 

@v-yuezhe-msft @LivioLanzo

Sorry but i already got it with this: https://powerbi.microsoft.com/es-es/blog/power-bi-desktop-august-2018-feature-summary/

Thanks for your attention 🙂

Kind regards 

[LivioLanzo]

You need create a dynamic link like this:

https://docs.microsoft.com/en-us/power-bi/service-url-filters

[Anonymous]

Thanks @LivioLanzo !!

It's possible with dynamic filters on url? not a static filter? 

Best regards . 

[LivioLanzo]

@Anonymous 

a dynamic URL can be created by using a DAX measure

[Anonymous]

@LivioLanzo

Do you know the formula or example?

Thanks again ! 

Regards. 

[LivioLanzo]

@Anonymous

I cannot provide a general formula as this depends on your model / visual.

The part of the URL that you need to make dynamic is this one:

?filter=Store/Territory eq 'NC'

If you take a look at my first reply, you can find a YouTube video from Guy In A Cube which explains how he uses it