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.
Hi,
I have a minor issue with one of my reports.
I have 4 tables connected through relationships, but only one link between each of them.
But the data between the 1st and the 4th table is not dynamic. how do i connect these tables?
Connecting the 1st " 04 FunctionTargets" and the 4th "08 Scrap reason codes" doesn't seem to solve the issue
Solved! Go to Solution.
hi, @Alanbo
1. If you want to the data between the 1st and the 4th table is dynamic,
you should keep all the cross filter direction is "Both"
2. for your data model, 10 and 08 is dim fact table and 04 and 07 are data table, the best data model should like this:
Then use all the dim fields from10 and 08 tables in visual and for filter.
Best Regards,
Lin
hi, @Alanbo
1. If you want to the data between the 1st and the 4th table is dynamic,
you should keep all the cross filter direction is "Both"
2. for your data model, 10 and 08 is dim fact table and 04 and 07 are data table, the best data model should like this:
Then use all the dim fields from10 and 08 tables in visual and for filter.
Best Regards,
Lin
Hi,
Thank you, I have it working now
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
61 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |