The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
126 | |
107 | |
87 | |
65 | |
60 |
User | Count |
---|---|
258 | |
121 | |
117 | |
99 | |
79 |