Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am hoping someone may have a creative solution to managing relationships in their models. I am familar and solid with the nature and behavior of my tables and the relations, but what I am hoping to find is a way to neatly organize my tables in the model tab.
If anyone knows of a snap feature or something that allows for the tables to quickly and uniformly be arranged I would appreciate the advice.
For the image below I know this only took a few minutes to arange, and this is a very simple report. I have additional reports with dozens of tables and dosenz of relationships.
Solved! Go to Solution.
@Anonymous unfortunately it is not a very clean design, but one thing I always do I add a separate page for a various relationships so that at one time it is easy to see the relationship between a small set of tables. Although I think the relationship diagram tab needs overhauling and need improvement.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi @Anonymous ,
I don't think currently if there is an automated way to do this. You need to do it manually.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
@Anonymous unfortunately it is not a very clean design, but one thing I always do I add a separate page for a various relationships so that at one time it is easy to see the relationship between a small set of tables. Although I think the relationship diagram tab needs overhauling and need improvement.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi @Anonymous ,
For more details, please take a look at the document.
Create and manage relationships in Power BI Desktop
Excepting the option, there isn't other workaround to manage them automatically. We still do it manually.
Hi Xue,
Thank you for getting back to my question. I'm familar with the nature of the relationships and model building. I am hoping to find a way to neatly organize it on the model tab so when there are dozens of relationsips and tables I can clearly congergate with a clean look. I was hoping to have something similar to the snapping function that is available when working with visuals.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |