Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
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
Best regards
Bruno Costa | Super User
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
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?
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