Forum Discussion
Filter Across Reports (using different Semantic Models) in Same App?
We are looking to break up one of our large, complex, and growing reports into several reports that rely on separate semantic models. Users want to be able to filter to their desired unit once, and w...
Hi paythepiper
To pass filter selections between Power BI reports in the same app:
URL Query Strings:
- Append the filter to report URLs using query parameters (e.g., ?filter=Table/Column eq 'Value').
- Use DAX to generate dynamic URLs and link them in your app navigation.
Power Apps:
- Embed a Power App to let users select a filter and store it in a central source (e.g., SharePoint).
- Reports retrieve the filter dynamically from this source.
Power Automate:
- Use a flow to store the user’s selection in a shared database.
- Reports pull the filter value during refresh.
For simplicity, URL query strings are often the easiest to implement.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂
Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS