cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
michaelswisher Frequent Visitor
Frequent Visitor

Re: How to Page Navigation in Power BI Desktop

I just developed a poor-mans solution to this problem using the drillthrough functionality.  A PrintScreen of the result is at the bottom of the post.

 

Create a disconnected table with one field and one value in the field.  I called my table 'Page Marker', the field 'Select Page', and the value 'Right Click to Select Page'.  The table name and field name are irrelevant, but the value will tell a user how to move to the page they want.  If you have room you'd want to be more verbose than mine.

 

Create a table visual on each page selecting the newly created field (Select Page).  I made the column header white so as to disappear, and removed the outline around the header.  I selected the Segoe UI font for the value, gave it a light gray background and selected Frame as the outline, all to make it stand out a little.  Copy that table to each of your report pages.

 

Finally, on each sheet put your new field (Select Page) as a Drillthrough filter.  Now, when you right-click on Right Click to Select Page, hover over Drillthrough and you'll be presented with all the sheets in your report, or at least those you added Select Page to the Drillthrough filters.

 

Drillthrough carries filters with it, which in this case would inadvertently mess up the page you're moving to.  By creating only one value in a disconnected table, nothing gets messed up.  It's not perfectly clean, but it does the job.  I did make a simple pbix example, but I don't know how to attach it.

 

If in the meantime you have found a better solution, I'd appreciate hearing about it.

 

 Simple Page Selection Example - Power BI Desktop.png

pritzlb Frequent Visitor
Frequent Visitor

Re: How to Page Navigation in Power BI Desktop

I have clients who love to fill the landing page with cards or gauges and you cannot use the drillthrough feature (a 16 year old feature in BI tools they added Sept 2017) in these visualizations.  Long way to go...

SanderW Frequent Visitor
Frequent Visitor

Re: How to Page Navigation in Power BI Desktop

Something similar can be achieved using the  bookmark feature now 🙂
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

Under the view tab in the top ribbon check the box labeled 'bookmarks'
Navigate to some pages and click 'add bookmark'
After creating some pages, add a shape to your overview page, and in the settings of the shape you will find link. Set the dropdown to 'bookmark' and select the bookmark you want the user to navigate to.

SanderW Frequent Visitor
Frequent Visitor

Re: How to Page Navigation in Power BI Desktop

With the bookmark feature something similar can now be achieved.
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks



In the ribbon under the view tab, make sure the bookmarks checkbox is checked.

Navigate to some pages, clicking 'add bookmark' in the bookmark pane on each page you want link to.

On your overview page, add a shape

in the shape's settings, you will find a 'Link' section
expand it and select 'Bookmark' as the navigation type
Select one of the pages you bookmarked as link.

Good Luck!

Highlighted
Tiff Regular Visitor
Regular Visitor

Re: How to Page Navigation in Power BI Desktop

Hi, 

 

You can try doing it with SIGNETS , this is what I'm doing. It works perfectly... 
But now I know the post is quite old ! 

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 6 members 3,389 guests
Please welcome our newest community members: