cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gopaltarakad Frequent Visitor
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

Accepted Solutions
Community Support Team
Community Support Team

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

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 Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
1 REPLY 1
Community Support Team
Community Support Team

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

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 Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 31 members 749 guests
Please welcome our newest community members: