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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
gopaltarakad
Frequent Visitor

Why doesn't this relationship structure work in Power BI?

Sorry for my bad diagram, but this sort of tree structure?

Capture.PNG

Where two levels have equal distribution of data, but the third level only references some fields from the previous tree structure?

 

 

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi,

 

>>Where two levels have equal distribution of data, but the third level only references some fields from the previous tree structure?

According to your description, you can use the single direction relationship mode:

 

1. Click on “Manage Relationships”.
 Capture3.PNG

 

2. Click edit to edit the relationships.
Capture4.PNG 


3. Modify the both relationship to single.

Capture5.PNG
 

Result:

Capture6.PNG

 

Use this relationship, you can’t use “Record Details” to filter records which in “Records Header”, as the arrow points to “Record Details”.

 

Reference:

Create and manage relationships in Power BI Desktop

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
v-shex-msft
Community Support
Community Support

Hi,

 

>>Where two levels have equal distribution of data, but the third level only references some fields from the previous tree structure?

According to your description, you can use the single direction relationship mode:

 

1. Click on “Manage Relationships”.
 Capture3.PNG

 

2. Click edit to edit the relationships.
Capture4.PNG 


3. Modify the both relationship to single.

Capture5.PNG
 

Result:

Capture6.PNG

 

Use this relationship, you can’t use “Record Details” to filter records which in “Records Header”, as the arrow points to “Record Details”.

 

Reference:

Create and manage relationships in Power BI Desktop

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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