I've been so far using the slicers for this report but as a phase upgrade we thought to move the slicers to the filter pane, that's when we encountered the issue which we were able to achieve in slicer but not in Filter Pane.
I wanna achieve cascading filter between two dimensions (Country & Division) in filter pane, which are all connected only through the fact tables & applying bi-directional filter is also not possible here, because the model contains two fact tables connecting with the other two dimensions.
Attaching the sample data of how my data looks like.
Dimensions - Country & Division and Fact - Organization & Organization History (Audit / SCD 2) table.
My data looks like below :-
Data Modelling :-
Dim Country & Org Fact (ID-CountryID)
Dim Division & Org Fact (ID-DivisionID)
Dim Country & Org Fact Hist (ID-CountryID)
Dim Division & Org Fact Hist (ID-DivisionID)