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.
Super Userhello WishAskedSooner
if you have unique ID between those facts, then i think you good to go since you will not have mixed value or wrong data relationship. I usually double check manually some values to make sure MMR create a correct result, but i guess you have done this already.
upload your test file in dropbox or any cloud storage and then drop the download link here.
Also dont forget to open the access so expert PBI here can download your test file.
Thank you.