cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DJL
Regular Visitor

Power BI App | Can one filter drive multiple reports?

Hi all,

We have implemented a Power BI app in order to consolidate two independent reports (ie: two separate pbix files)  These reports have commonality in that they focus on generating analysis against an identical cohort of suppliers.

It is worth declaring that it is the significant complexity behind each report which determined the decision to separate them.  In our scenario, it is not an option to create one data model.

Currently, the consumer has to filter each report to whatever supplier they're reviewing.  From a UX perspective, we're wondering if it's possible to link the filter between the reports in some way?

Any thoughts most appreciated.

Thanks 😊

1 ACCEPTED SOLUTION
SpartaBI
Community Champion
Community Champion

@DJL you can use the drillthrough feature to go from one report to the other with the selection that came from the 1st report already applied to the 2nd. There are some considirations and twiks you need to be aware of. Read this article:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-cross-report-drill-through?tabs=pow...


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png


Showcase Report – Contoso By SpartaBI

Full-Logo11.png

SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

View solution in original post

3 REPLIES 3
SpartaBI
Community Champion
Community Champion

@DJL you can use the drillthrough feature to go from one report to the other with the selection that came from the 1st report already applied to the 2nd. There are some considirations and twiks you need to be aware of. Read this article:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-cross-report-drill-through?tabs=pow...


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png


Showcase Report – Contoso By SpartaBI

Full-Logo11.png

SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Hi Sparta,

Thanks for the reply and the suggestion 😊

I've taken a look and whilst I can see this would meet some use cases it's a bit too fiddly and unintuitive for how I'm looking to deply a cross-report filter.  I'm probably describing a feature which doesn't yet exist: something like an 'App Level Filter' which the consumer can select and cascades into whatever reports within the App share that common field.

But thanks for the input - it's always worth asking!

Thanks,

DJL

SpartaBI
Community Champion
Community Champion

@DJL my pleasure 🙂 And yes, you are right 🙂
Please don't forget to accept the previous message as a solution for community visibility.
P.S. Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. Please give it a thumbs up over there if you liked it 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.