Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
cheid_4838
Helper II
Helper II

Moving Relationships

Not thinking I created different groups of relationships for different dashboards in one layout instead of creating a new layouts for each.  Can you move relationships to different layouts for improved organization? Thanks.

1 ACCEPTED SOLUTION
AmiraBedh
Resident Rockstar
Resident Rockstar

In Power BI, you cannot directly move relationships between different layouts because the relationships are managed centrally in the model itself, not per layout or report page.

 

If your data model is complex and you need different layouts to represent different logical groupings of relationships, consider refining your data model. You might use calculated tables or different measures that are specific to certain aspects of your data. This doesn't change the underlying relationships but allows you to focus on different parts of the model in different report contexts.


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

View solution in original post

3 REPLIES 3
AmiraBedh
Resident Rockstar
Resident Rockstar

In Power BI, you cannot directly move relationships between different layouts because the relationships are managed centrally in the model itself, not per layout or report page.

 

If your data model is complex and you need different layouts to represent different logical groupings of relationships, consider refining your data model. You might use calculated tables or different measures that are specific to certain aspects of your data. This doesn't change the underlying relationships but allows you to focus on different parts of the model in different report contexts.


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

That is what I thought.  I was asked to create one dashboard file that would contain multiple dashboards that were previously in SSRS. Most of the dashboards have their own set of relationships since they are unrelated to each other.  I should have put them in their own layout for better organization.  Thanks for your quick response.

Don't forget to accept my answer if it helped you 😄


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.