Forum Discussion
Button with filter parameters
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.
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 regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
3 Replies
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 regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicHey 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 regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
