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 3 tables.
1) Customer Table
2) Accounts Tabble
3) Customer_Accounts Table
One customer could have many accounts and simmilarly One account could have multiple customers. for eg
Customer Table
customerID | customerName |
1 | A |
2 | B |
3 | C |
Accounts Table
accountID | accountName |
4 | ABC |
5 | DEF |
6 | GHI |
Customer_Account Table
customeraccountid | customerID | accountID |
1 | 1 | 4 |
2 | 1 | 5 |
3 | 2 | 6 |
4 | 3 | 6 |
There is a relationship between Customer Table , Accounts Table and Customer_Account_Table.
I have to create a dashboard where if I search for customer in the customer table, I should get the Accounts it belongs to from the Accounts table and simmilarly, if I search for Accounts in the Accounts table , I should get all the customers that belong to that account.
Could you please tell me how can I achieve this.
Thanks
Solved! Go to Solution.
Hello @AmrutaKar
you have to set the cross filter direction to "both"
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hello @AmrutaKar
you have to set the cross filter direction to "both"
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
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 |
---|---|
41 | |
30 | |
26 | |
21 | |
17 |