I have read here that PowerBI now supports bi-directional filter using power query.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-bidirectional-filtering/
I installed the new powerbi version, but once I go on options as described, this option does not seem available for me on the preview features.
I am building a model connected to Analysis Services with multiple Fact Tables, and this would be very much in handy, since the report uses slicers to filter the report.
If somehow this it not possible and since these relationships are merely to filter the report, I guess I am only left with trying to merge these tables into one right?
Thanks guys!
This is what I was looking for