Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
101 | |
75 | |
67 | |
61 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |