How apply general filter on multiple reports ?

[andine]

Hello Community,

I am encountering an issue with a Power BI app I've created. The app contains multiple reports, each on a separate tab. The challenge is that I have a global filter (for location) that should apply to all reports when changed by the user. For instance, if a user selects a location on the first report and navigates to another tab (a different report), the same filter needs to be retained. How can I achieve this?

Thank you for your assistance!

[danextian]

hi @andine 

Assuming that you what you mean by the same report is the same pbix (as that is considered a single report in Power BI's term), you can create a location dimension table which has a column of all locations and relate that to all fact tables. Use the column from location table when slicing the other tables.  Below is an example of a multi fact tables connected by a calendar table. Guy in the cube discussed this one of their vlogs.

[andine]

Hello,

Thanks for your answer but actually I have multiple pbix and the filter needs to be applied on all of them.

BR

[danextian · Accepted solution]

I don't  think what you're trying to do is achievable. Slicers and filters from the filter pane work only within the same pbix. You  can use RLS or cross report drillthrough but the fltering is not based on a slicer selection but rather on the user's assigned role or from a drillthrough action. Honestly, if I were the one who created these reports and the goal  was to be able to synch the slicers across all tabs, I'd place them all within the same pbix even if the separate reports were from different semantic models. If this is a request from the stakeholder to have them separate and still make them synch, I'll make them understand that it is currently not supported.