Button with filter parameters

[M-M-P]

Hi All
I need your help to resolve this.

As you can see in the picture below, I have an Overview page and a Data page.
My wish is that when you click on a button, it switches to the Data page which is then filtered down to the data the button is selected to filter. So if you click on Room 3, then data from Room 3 will be displayed on the Data page.

Right now I have one page per room and it is very time consuming to maintain.

I have been working with page drilling through. But from a user perspective, this is not a path I want to take if I can avoid it.

Thanks in advance.

[selimovd · Accepted solution]

Hey @M-M-P ,

drill through is the wrong tool for that.

Take a look at bookmarks, it's exactly what you need for your case:

Use bookmarks in Power BI Desktop to share insights and build stories - Power BI | Microsoft Docs

Or check it out in the Guy in a Cube video:

Mastering Power BI Bookmarks - YouTube

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[M-M-P]

Hi @selimovd 

Thanks for your reply 🙂

So, your solution is to have a bookmark per room?
It is definitely an easier solution to maintain.

[selimovd]

Hey @M-M-P ,

exactly. Each button on the overview page is a bookmark to the data page with the pre defined slicers.

If you want you can then also add another bookmark on the data page that is bringing you back to the overview.

Let me know if that works for you.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic