Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
hello my date filter does not affect 3 images when it should. that is why, ii created a date table (you can see it is on the right), i connected it with table 4, and my date filter affected it (successful), then i think that i need to connect my table 5 with 1 and 3 but the system says that, " there is a reletionship already between 5-1 that is why the system does not activate the relationship. How should i do, i am really bad stuck, is there any way to solve this. Thank you
@date
Solved! Go to Solution.
that is probably because all your relationships are set to biredirectional ie (both) change them to single. You should have a 1 to many single relationship betweeen all your tables and your date table. Your date table is the 1 side and your transaction tables are on the many
Proud to be a Super User!
you should ideally have one date table and that date table should link to all your tables that have dates in them, you then filter your date by your date table.
Proud to be a Super User!
Yes i created date table and i tried to linked that table with others but the system did not allow me to do this
that is probably because all your relationships are set to biredirectional ie (both) change them to single. You should have a 1 to many single relationship betweeen all your tables and your date table. Your date table is the 1 side and your transaction tables are on the many
Proud to be a Super User!
User | Count |
---|---|
89 | |
88 | |
75 | |
67 | |
58 |
User | Count |
---|---|
137 | |
110 | |
91 | |
84 | |
69 |