Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Sorry for my bad diagram, but this sort of tree structure?
Where two levels have equal distribution of data, but the third level only references some fields from the previous tree structure?
Solved! Go to Solution.
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”.
2. Click edit to edit the relationships.
3. Modify the both relationship to single.
Result:
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
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”.
2. Click edit to edit the relationships.
3. Modify the both relationship to single.
Result:
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |