A redesigned Manage Relationships window

This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Power BI Desktop Update for May 2024 Part seven of a seven-part series of blogs
This month's bigger than average update sees new pivot table style matrix layouts, the emergence of modern tooltips, calculation groups and the DAX query pane from preview and a couple of other smaller changes. Power BI Desktop Update for May 2024 Making matrices behave more like Excel pivot tables Modern tooltips are now turned on by default DAX query view has emerged from preview Model Explorer and Calculation Groups are now generally available More line formatting enhancements A redesigned Manage Relationships window (this blog) We've been creating our idiosyncratic monthly blogs on Power BI updates since November 2016, and also deliver online and classroom Power BI courses.

Power BI Desktop Update for May 2024

Part seven of a seven-part series of blogs

This month's bigger than average update sees new pivot table style matrix layouts, the emergence of modern tooltips, calculation groups and the DAX query pane from preview and a couple of other smaller changes.

Power BI Desktop Update for May 2024
Making matrices behave more like Excel pivot tables
Modern tooltips are now turned on by default
DAX query view has emerged from preview
Model Explorer and Calculation Groups are now generally available
More line formatting enhancements
A redesigned Manage Relationships window (this blog)

We've been creating our idiosyncratic monthly blogs on Power BI updates since November 2016, and also deliver online and classroom Power BI courses.

Posted by Andy Brown on 04 June 2024

There is a new Manage Relationships button on the Home ribbon:

This button is (apparently) new!

You can use this to view all of the relationships in your data model:

You can clearly see the directionality and status of every relationship.

One additional useful feature is that you can choose to view only relationships of a certain type:

You can choose to filter by relationship type (as shown above) or by cross-filter direction.

The Autodetect button in the Manage Relationships window will try to find existing relationships between tables in your model, although in most cases these will have been picked up when you loaded the relevant tables into your data model.

Parts of this blog
Power BI Desktop Update for May 2024 Making matrices behave more like Excel pivot tables Modern tooltips are now turned on by default DAX query view has emerged from preview Model Explorer and Calculation Groups are now generally available More line formatting enhancements A redesigned Manage Relationships window (this blog)