Forum Discussion
How apply general filter on multiple reports ?
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.
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.
Hello,
Thanks for your answer but actually I have multiple pbix and the filter needs to be applied on all of them.
BRI 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.
