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.
I have 2 tables:
Sent
NL 1 | 08/05/2024 00:00:00 |
NL 2 | 05/02/2024 00:00:00 |
NL 3 | 20/04/2024 00:00:00 |
NL 4 | 24/07/2023 00:00:00 |
Open
NL 1 | 20/05/2024 00:00:00 |
NL 2 | 05/05/2024 00:00:00 |
NL 3 | 20/06/2024 00:00:00 |
both are connected via a 1:* relationship to a date table.
If I create a simple dashboard with the 2 tables and a date slider, one table is filtered as expected (the records outside the date range are not shown), while the other table doesn't show any records at all!
looking at my example, if I select all 2024 I'll see 3 records from the sent table and NONE from the open table.
Any idea what could be the issue? both table have also other relationships, but I can't see as being an issue, after all if I remove the
date relationship I can see all records from the open table
Adding a couple of screenshots for clarity
TIA
Solved! Go to Solution.
Hi @df123445
If the sent ID is the same as open ID, I'd recommend you to combine the two separate fact tables in one table which contains information of sent and open in same rows and have it as a disconnected table with your calendar table in order to perform flexible analysis with respect to the time dimension.
Best regards,
Hi @df123445
If the sent ID is the same as open ID, I'd recommend you to combine the two separate fact tables in one table which contains information of sent and open in same rows and have it as a disconnected table with your calendar table in order to perform flexible analysis with respect to the time dimension.
Best regards,
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |