Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

URLs Power Bi Desktop

Hi Experts   How do you do the following " Say you're working in Power BI Desktop. You want to create a report that has links to other Power BI reports, but you want to show only some of the i...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous ,

     

    It can be achieved by measures.

     

    Report URL = "https://msit.powerbi.com/groups/me/reports/xxxxxxx/ReportSection"

Report Filter = IF(ISFILTERED(Table3[Column1]),[Report URL]&"?filter=" & "Output/Employee" & " eq " &"'" & SELECTEDVALUE(Table3[Column1]) & "'",[Report URL])

    Replace the report URL, table name, column name with your own values in above measure formulas.

     

    Best regards,

    Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Yuilian Gu, firstly thanks for the excellent feedback as always. here is a silly question. Can you make the url dynamic show - say if i filtered on a slicer that change is reflected in the URL i.e. we have a updated URL to reflect the action i have just preformed..

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Anonymous ,

 

It can be achieved by measures.

 

Report URL = "https://msit.powerbi.com/groups/me/reports/xxxxxxx/ReportSection"

Report Filter = IF(ISFILTERED(Table3[Column1]),[Report URL]&"?filter=" & "Output/Employee" & " eq " &"'" & SELECTEDVALUE(Table3[Column1]) & "'",[Report URL])

Replace the report URL, table name, column name with your own values in above measure formulas.

 

Best regards,

Yuliana Gu