Forum Discussion
Continued ContributorSyncing Hierarchical Date Slicers Not Working
Continued ContributorThank you so much for your quick response! I apologize for leaving out the detail that the MMR join between Fact Table A and B is not on Date. Rather, they are joined on an ID column that is unique, just not to these two Fact Tables.
The only reason I mention the MMR is to point out that the DimDate table doesn't filter Fact Table B. Maybe there is another way around this via the data lineage that doesn't require a second Slicer? That would be ideal actually. But, I am not quite sure how to go about it.
Your suggestion to create a unique ID to join on is clearly another possibility.
Sadly, uploading a test file is not possible. Although I might be able to re-create this scenario from the Contoso Sample.
Please share some sample data and expected outcome. This could help forum users understand your question better and find a possible solution or alternative more quickly. THis blog should be helpful: How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Jing