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

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

Hi Anonymous ,

 

Yes. Firstly, you should generate a new URL by appending query string parameter to it to filter a specific report which has been published to service. Copy that URL into a table, set its data category to "Web URL" so that it will be dispalyed as a link in table visual. Alternatively, you can directly insert a Textbox to show that URL.

Publishing and sharing this new report in Power BI Service, end users can jump to the related reports by clicking the links.

 

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Yuiliana Work prefectly, many thanks. going to post another follow up question.