Forum Discussion
How to Page Navigation in Power BI Desktop
- 10 years ago
Great idea u have , Its working in tableau .
But here there no option to do like this sorry,
Hope in future they will add
- 10 years ago
Try to search for an idea that fits your wish (https://ideas.powerbi.com/forums/265200-power-bi-ideas).
- 10 years ago
How to create a link between Page1 to Page2 in power bi desktop ,like Hyperlink same as in the Excel.I tried create a link between the pages using the text area but it is not working.
I think the reason Excel containing the link between pages is that there're occasions referencing cells from other sheets.
However the pages in power bi are visualizations and all the data can be seen in the data view and referenced in the report. So In my personal opinion, I don't see a necessity of that feature, you can switch pages by clicking on the page tab. However you can still report this idea on power bi ideas and people who have the same requirement would vote it up.
Great idea u have , Its working in tableau .
But here there no option to do like this sorry,
Hope in future they will add
- michaelswisher8 years ago
Advocate I
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.