Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
v-yiruan-msft
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
v-yiruan-msft
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.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.