Power BI Blog: Managing Relationships

Welcome back to this week’s edition of the Power BI blog series.  This week, we look at the recently added ‘Manage relationships’ button.  Hmm… I wonder if that works for personal lives too?

There is a redesigned ‘Manage relationships’ dialog in Power BI Desktop.  To open this dialog, simply select the ‘Manage relationships’ button in the Home tab on the Ribbon.

Once opened, you’ll find a comprehensive view of all your relationships, along with their key properties, all in one convenient location.  From here you can create new relationships or edit an existing one, viz.

Additionally, you have the option to filter and focus on specific relationships in your model based upon cardinality and cross filter direction.

To make things even easier, Power BI can find and create relationships for you by selecting the ‘Autodetect’ button.

In the meantime, please remember we offer training in Power BI which you can find out more about here.  If you wish to catch up on past articles, you can find all of our past Power BI blogs here.