Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |