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

Remaining Report level Filters with Bookmarks?

Hello there,

 

I am using a report with different sheets and with a report level filter for all of these sheets, e.g. the quater. If the quater changes, I only change the filter from Q2 to Q3 and every sheet is correct.

Further, I have an "Agenda sheet" in the beginning with bookmarks. 

There I can click on shapes with the name of the topic I would like to see (1 topic = 1 sheet). The shape has an action with a bookmark to the sheet, so I do not need to search for the sheet in the row at the bottom, I will directly land on the sheet.

 

The bookmark has the current report filter in it, e.g. Q2.

If we change now from Q2 to Q3, is there a possibility that I don't need to update every single bookmark?

If I change the filter from Q2 to Q3, but I click on the shape with the bookmark action, it will lead to my sheet but with the wrong filter..

Do you have a solution for me?

 

Thanks in advance and best regards

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Remaining Report level Filters with Bookmarks?

Hi @mistertobi_1997 ,

Yes, I'm afraid that we cannot achieve your requirement with bookmark currently in power bi.

You may try to Sync slicer rather than report level filter as a workaround and set the bookmark like below.

Capture.PNG

More details, please refer to my test file.

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.

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: Remaining Report level Filters with Bookmarks?

Hi @mistertobi_1997 ,

By my tests with your scenario, if we save the bookmark for sheet1 with the report level filter to be Q2, and if you change the report level filter from Q2 to Q3 in the main page, when you click the Bookmark to sheet1, it will show the data of Q2. Please refer to my attachment.

What is your desired output?

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.
mistertobi_1997 Frequent Visitor
Frequent Visitor

Re: Remaining Report level Filters with Bookmarks?

Hi @v-piga-msft ,

 

thanks for your response.

Your scenario shows my problem: If I change the quater from Q2 and to Q3, and then click on the bookmark, I would like to have the updated quater Q3 on the page and not the Q2 from the bookmark..

But I am afraid that this isn't possible with bookmarks or this is against the functionality of bookmarks.

 

Thanks and br

 

Community Support Team
Community Support Team

Re: Remaining Report level Filters with Bookmarks?

Hi @mistertobi_1997 ,

Yes, I'm afraid that we cannot achieve your requirement with bookmark currently in power bi.

You may try to Sync slicer rather than report level filter as a workaround and set the bookmark like below.

Capture.PNG

More details, please refer to my test file.

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.

View solution in original post

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 109 members 1,550 guests
Please welcome our newest community members: