add hyperlink (Power BI Report URL) and navigate to different report

[Varun511]

HI,

have a requirement where i need to add a button whenever user clicks on the button it will navigate to a different report (ideally need to add URL of that particular report which sits in server)

can any one help me on this?

Thanks,

varun

[pattersonm8]

i still couldn't get to work from measure, but could put a table with the link icon and worked

[v-cgao-msft · Accepted solution]

Hi @Varun511 ,

For reports, you would need to have a table with the URL that you want and categorize it as a URL. For example.

You can then create a measure for each report like this.

report1 = CALCULATE(MAX('Table'[URL]),FILTER(ALL('Table'),'Table'[report]="report_1"))

Create a blank button.

Format button.

And set the previous measure to the action.  

You can repeat the steps to set up such a button for multiple reports.

Save and Publish. When you open a report in the service and click on these buttons, the browser will create a new tab to open the report.

Best Regards,
Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[amitchandak]

@Varun511 , You can power bi report URL from power bi service and use it

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