cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
drorli
Helper I
Helper I

Preserve filter in layout with multiple backgrounds, when access is drill-through from other report

Hi, I would like a team developing a tabbed dashboard for me to use a UI approach that each sheet (accessed via bookmark) have a slightly different background. I am seeking for them to implement layout in a manner similar to how it is done in the layouts in https://powerbi.tips/ (i.e. https://powerbi.tips/product/layouts-sunset-free/).

 

I am being told that this approach is impossible, which I find improbable ...

The limitation raised by the developer is "if we want to use drill through from other page into our dashboard, then we should use a single page for our layout".

The reason given is that a filter value passed when drilling into our report will be available only on the launched sheet/page and when we follow the bookbark to a different page within the report the value passed-in an applied on 1st sheet/page will be lost.

 

Is this a real limitation?

If not, can you help me guide developer who to preserve a value passed-in on filters across pages within a report?

 

1 ACCEPTED SOLUTION
yingyinr
Community Support
Community Support

Hello @drorli ,

Review the following documentation and see if they can meet your requirements.

Add a report-level filter to filter an entire report

Synchronize and use targeting on other pages

Best regards
Community Support Team _ Rena Rouan
If this post helps,then consider Accepting it as the solution to help the other members find it more.

Community Support Team _ Rena
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

2 REPLIES 2
yingyinr
Community Support
Community Support

Hello @drorli ,

Review the following documentation and see if they can meet your requirements.

Add a report-level filter to filter an entire report

Synchronize and use targeting on other pages

Best regards
Community Support Team _ Rena Rouan
If this post helps,then consider Accepting it as the solution to help the other members find it more.

Community Support Team _ Rena
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

Thank you. Meanwhile I was told that we can use slicer+navigation on the source report instead of drilling. 

Asked team to check the links you sent.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.