Slicer not showing all dates when project slicer is changed

[MollieCraig]

Hi all,

I am needing a solution to the following:

My submission slicer is based on a date table that uses quarters. I am trying to understand why, when I change my project slicer, all the dates disappear from the submission Slicer.

A background into the data is that the M6 has dates dating back until 4-2019 whilst the other projects only date back until 4-2021 - is it possible that this is the source of the issue? 

Any help is appreciated! 

[onurbmiguel_]

Hi MollieCraig

Check in "Manage relationships" if you have "Both" in cross filter direction.

You need to difine wich table filter the ohter. 

Any questions please ask

Best regards

Bruno Costa | Continued Contributor

Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍

Take a look at the blog: PBI Portugal 

[MollieCraig]

Hi Bruno, 

Thanks for your help!

My date table (Submission slicer) and my Project table (Project Reference slicer) are both in one to many relationships with my main table which has my data fields in, so are not directly linked to each other - is this where my problem lies?

[v-easonf-msft]

Hi, @MollieCraig 

It is not ruled out that it is caused by the model relationship.

If possible, please share relevant screenshot for further search.

Best Regards,
Community Support Team _ Eason