Forum Discussion
Page navigation with button whilst preserving filter values
Hi,
I have a report with multiple start pages which are all different and have different country filters. For each of these start pages I have 4 detail pages which are all identical except the filtering changes based on the start pages those are navigated from. E.g., when navigating from the US start page the detail pages should all have inherited filter US, and when navigating from Canada start page those same detail pages should now have inherited Canada filter. When navigating from one detail page to another the filter should remain the same.
In addition, the requirement for the start page is that the end user only has to select the page they want to navigate to, nothing else.
Basically, I'd like a button with navigation without selecting any other data or slicers and that the navigation takes into account the existing page-level filter in the start page.
I don't want to use bookmarks.
How to do this?
Hi jen_blue
I wonder if you're talking about a sync slicer.
On the details page, use the same country filter as on the start page.
You can do this by using the "sync slicer" feature in Power BI.
sync-and-use-slicers-on-other-pages
If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
9 Replies
Hi jen_blue
Daniel29195 Thank you very much for your prompt reply and here allow me to share some of it.
To implement dynamic page navigation in Power BI without using bookmarks, you can utilize the page navigation feature as well as the conditional formatting settings.
First, create a table containing the names of the pages to navigate to. This table will act as a slicer for navigation. This slicer will allow users to select the page they want to navigate to.
NavigationTable = DATATABLE ( "PageName", STRING, { {"US Detail Page"}, {"Canada Detail Page"}, {"UK Detail Page"}, {"Australia Detail Page"} } )Insert a button on the start page. Go to the Action property of the button and set the Type to Page Navigation. Create a measure to capture the selected page.
SelectedPage = SELECTEDVALUE(NavigationTable[PageName])Use conditional formatting to apply this metric to the button's “Destination”.
You can now select the slicer on the navigation page and use the buttons to navigate to the page.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you Anonymous for your reply and detailed instructions.
However, to clarify my goal here I was wondering if it is possible and if so how to have the setup other way round like you explained. So, that I have starting page for US, Canada, UK and Australia and from those starting pages the user can then navigate to identical detail pages except those have inherited the country filter from the starting page.
- Daniel29195
Community Champion
may i ask the reason why you are having 4 different starting page where each page is filtered with a unique country ?
The aim is, when publishing an application of this report all the different starting pages can be seen in the left panel. Also, all the starting pages are different. From those starting pages the user can then navigate to detail pages which are identical (e.g. sales, marketing, hr, etc.) and filtered using the country from starting page.
Does this explanation make it clearer?
- Daniel29195
jen_blue you can use url filters.
check the link below.
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters
I tried url. Is it possible to make the button in pbi report with url to make it open in the same browser tab and how this can be achieved with published app?
- Daniel29195
that is the drawback . i dont think you cant . jen_blue
Hi jen_blue
I wonder if you're talking about a sync slicer.
On the details page, use the same country filter as on the start page.
You can do this by using the "sync slicer" feature in Power BI.
sync-and-use-slicers-on-other-pages
If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, I'm at the same point.
My dashboard has 5 pages with different concepts and a sixth page with a common KPI for all other pages. I'd like to use page navigation to be able to filter the sixth page (common page) with the report I came from. I've got a table with a unique ID used to identify each page. I've tried using the slicer as you mentioned, but it's not working as I expected, or maybe I'm using them in a bad way. When I synchronise the slicer between all pages, I can't select a different ID for each page/ID, as once I select it for the first time on one page, it is shared across the whole dashboard.
For example, I'm on page B and I click on the "Show KPIs" button to go to the common page where the information shown should be filtered by page B's ID. If I'm on page C, i want to press other button and go to the common page filtered by page C's ID. Is this possible?
Thank you in advance
