Page navigation with button keeping filter values

[MarkTower]

Hi!

My dashboard has 5 pages, each one showing info about a different department with different charts, objects and structure. There is also a sixth page with common KPIs shared by all deparments. I'm looking for a way to pass the deparment ID of each page to the "common KPIs page" for filtering it. I want to use a button for navigation.

I've tried with Sync slicer, but it's not working as I expected. 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. What i need is to pass the department ID of each report to the "common KPIs page".

On the other hand, I have almost managed to get it to work with page drill-through. For this approach I have a visual with the department IDs and I need to have one selected in order to enable the button. It works, I'm able to filter the common page from each page passing the department ID, however when I go back to the previous page (back button) the selection is reset and the button is disabled.

Please, is there any way to avoid this behaviour for the "back" button? if not, how could i achieve what i want?

Thank you in advance
greetings

[v-nmadadi-msft]

Hi @MarkTower   ,

We have not heard back from you if any of the answers has met your requirement kindly  Accept it as the solution  to help out other community members or get back to us with any other questions.
Thank you

[MarkTower]

Hi @lbendlin 

I'm not sure what do you expect with the first two questions. 

The shared common KPIs page have 6 bookmarks to organise the KPIs according different categories. We don't want to manage and maintain 6 bookmarks for each department (30x), each time we need to perform any change it should be done 30 times. For this reason, we want to reuse the common KPIs page using a filter passed from a previous page (department ID).

Kind regards

[v-nmadadi-msft]

Hi @MarkTower  ,

Unfortunately it is not possible to retain the last selected data once you press the back button, Power BI desktop does not support that feature.

Although if you are using Power BI service you can try a feature called Persistent filters to get the result you are looking for.

Announcing Persistent Filters in the Power BI Service | Microsoft Power BI-Blog | Microsoft Power BI

If you are unable to use Power BI service I would suggest you to create Bookmarks in the department pages (5 pages) for the drill through and the KPI page anyway has bookmarks.

In this way you will be able to pass the department ID of each page to the common KPIs page for filtering it.

Hoping the provided solution matches your requirements.

If this post helps then please consider to  Accept it as the solution to help the other members find it more quickly.

Thanks and Regards

[MarkTower]

Thanks @v-nmadadi-msft for your reply.

We're using Power BI Report Server, and i don't see the persistent filter button as it's mentioned in the document which you linked (although i found the persistent filter configuration option on the report settings).

I'd appreciate you if you could elaborate on your suggestion to use bookmarks in department pages for the drill trhough. Although using the page drill-through works, we came out with the back button behaviour. Do you mean to add 5 buttons on the common KPIs page linked to the 5 department ID's bookmarks-pages, so we could go back?

Thanks in advance

Kind regards

[v-nmadadi-msft · Accepted solution]

Hi @MarkTower  ,

As you mentioned you don’t want the selected visual to not get reset once you click the back button in common KPI page as this is not feasible it would be better to create a

bookmark where the required fields are selected so you can drill through like that. Once you get back from the common kpi page and it gets reset you can click on the required bookmark to get the desired state back.
This is the best alternative approach if you are not able to use power BI service.

Hope this clarifies
Thanks and regards

[MarkTower]

Thanks for your help @v-nmadadi-msft

Yeps, we eventually have to use bookmarks because there is not other way to get it to work as we expected. I think Power BI should improve a lot on these usability and UX issues.

Thanks again for all your time and interest.

[lbendlin]

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com

[lbendlin]

- has anyone asked for this?

- who is the intended audience?

- what are the insights they are supposed to get out of this page?

- are you reducing the "number of clicks to insights" or are you increasing it?