Navigate Between Pages of a Dashboard via Hyperlink

[sagarmehta89]

I have a page in my report called Table of Contents

Say- 

Table of Contents:

A

B

C

D

What I would like is that if someone clicks on A, it would navigate him to "page A" in the report.

Is it possible to do this in Power BI?

[GilbertQ]

Hi @sagarmehta89

It is possible to do this, the trick is that each time you click on the link it will open in another tab in your Internet Browser.

I did watch the keynote at the Microsoft Data Insights Summit where in the next 3 months they are going to release a feature called "Drill Through" which will allow you to drill from one page to the next. Which is exactly what you require.

How urgent is this requirement to link pages, considering that it does take a fair bit of work, which within a few months will be done with a click?

[sagarmehta89]

@GilbertQ: Thanks for your help.

Do you have any documentation or .pbix file where you have implemented this?

It is little urgent and I think I can use your solution for now.

[GilbertQ · Accepted solution]

Hi @sagarmehta89

What you would need to do is the following steps below.

1. Upload your report to Power BI Service (The reason for this is you need to get the full URL link, which is based on multiple GUIDs in the Power BI Service.
2. Then go into your Power BI Report in the service.
   1. You will then see that the URL will change for each page/sheet in your report.
   2. It will change at the end of the URL and will have "ReportSection" for the first sheet created, and then "ReportSection1" for the second one etc.
   3. NOTE: You will need to algin which page/sheet name corresponds to the ReportSection 
   4. Copy the full URL's for each page/sheet
3. Then go back into the Power BI Desktop File, and click on Enter Data
   1. Then take the Above URL's and put them into your table.
   2. Load the table into your Power BI Model.
   3. Go into your table and make sure to change the Data Category is set to Web URL in the Modeling Properties
4. Now you can create a table with your links above.
   1. You can go into the Format Option for the table and then under the Values, there is an option for URL Icon, and enable this.

Now re-upload your Power BI Desktop file to the Power BI Service and that should now work.