Forum Discussion

WishAskedSooner's avatar
WishAskedSooner
Icon for Continued Contributor rankContinued Contributor
1 year ago

Syncing Hierarchical Date Slicers Not Working

I know this has been asked and answered before, but for the life of me I can't get this to work even after trying many of the suggestions. I believe I may have stumbled upon one of PBI's limitations,...
Need Help
Irwan's avatar
Irwan
Icon for Super User rankSuper User
1 year ago

hello WishAskedSooner 

 

I have two Fact tables, A and B, joined by an MMR. And before you say, whoa! there's your problem, trust me, it is the only solution to my business requirements.

MMR between fact is usefull in some cases as long as you have a unique value so it will match correctly between those facts.

 

Now, for obvious reasons, I want a hierachical slicer for Date Slicer A. However, as soon as I make the slicers hierarchical, sync'ing no longer works. Sad face.

if the MMR use date column, perhaps try to have MMR that is not date column (for example, create concatenate value in calculated column).

 

it would be great if you have a sample data so expert PBI here can have it checked for you.

 

Thank you.

WishAskedSooner's avatar
WishAskedSooner
Icon for Continued Contributor rankContinued Contributor
1 year ago

Thank 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.

  • Irwan's avatar
    Irwan
    Icon for Super User rankSuper User
    1 year ago

    hello 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.