cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kraman Frequent Visitor
Frequent Visitor

Passing filters to bookmarks in Power BI

I have built a report with multiple pages - say Page 1,2,3,4. On the first page, I have a map visual and have added drillthrough to the all the pages 2, 3, 4.

Now on the 2nd page, I have some images using which I want to navigate to the other pages(pg 3, 4) and have created bookmarks for them.

 

First I navigate to page 2 from page 1 using drillthrough. After that, when I navigate to those bookmarks from pg 2, the drillthrough filters that were applied in page 2 are getting removed. I have tried with "Keep All Filters" on and off but it didn't helped. What am I missing here ? Or is there a better way to implement this ?

7 REPLIES 7
Seward12533 New Contributor
New Contributor

Re: Passing filters to bookmarks in Power BI

In the bookmark options uncheck DATA.

 

capture20180808161756546.png

Highlighted
kraman Frequent Visitor
Frequent Visitor

Re: Passing filters to bookmarks in Power BI

I have already unselected 'Data'. Display, Current page and All Visuals are selected as of now. 

More Info: There is a chicklet slicer in pg 2, 3, 4 but these cannot be synced using sync slicer as chicklet is a custom slicer.

 

When I drillthrough from pg 1 to 2, chicklet in page 2 is filtered because of the drillthrough. I want this drillthrough filters to be applied on my bookmarks as well when I navigate to bookmarks of page 3 and 4.  

Seward12533 New Contributor
New Contributor

Re: Passing filters to bookmarks in Power BI

Until you can sync slicers with custom visuals may not work. In this case I use the standard slicer. If you want buttons change your chicer clicker to standard slicer, leave as list (ie don’t set it drop down) then in the format properties under top top section (general maybe?) change it to from vertical to horizontal and then it will switch to buttons.

May not work well for you if you have a large number of choices as they occupy a large amount of real estate since the buttons ware heavily padded. Otherwise leave as vertical and change to drop down.

Id show you a screenshot but on my mobile.
Community Support Team
Community Support Team

Re: Passing filters to bookmarks in Power BI

Hi @kraman,

 

Have you solved your problem?

 

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

If you still need help, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
kraman Frequent Visitor
Frequent Visitor

Re: Passing filters to bookmarks in Power BI

Hi @v-piga-msft

 

Above solution proposed was a workaround which unfortunately doesn't suffice my needs. I will create a dummy pbix and share here to get more help.

 

Regards,

Raman

pavan2 Frequent Visitor
Frequent Visitor

Re: Passing filters to bookmarks in Power BI

Hi All, I had simillar problem where i was unable to pass filters into my boomark... If some once can help me on this... Attached sample Pbix file for reference.

 

 

https://drive.google.com/open?id=1XOxA9mQEsZxLngVK-AeMSZB-2zVoOrhq

 

 

Thanks Pavan

AnnZwicker Occasional Visitor
Occasional Visitor

Re: Passing filters to bookmarks in Power BI

Was that issue resolved? I am also trying to use bookmarks, but want to ignore the filters set at the time the bookmarks were created.

Each time the user viewing it is a filter, and the time periods are other filters. They change for each viewer.

I read that Microsoft will be enabling synchronization of chiclet slicers in July 2019, and want to use them instead of standard filters, if possible.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 41 members 1,416 guests
Please welcome our newest community members: