Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Kindly advice, I have Three columns I want to create hierarchy slicer so that when I select Subject I will be able to see all the relationship on hierarchy column Subject for example; I have added Hierarchy relationship for a reference purpose to show how the data flow on slicer perspective on the Subject column.
Code: Subject Hierarchy Relationship
400 History Parent
400-10 History Year 7 Child
400-11 History Year 9 Child
400-12 History Year 11 Child
500 Maths Parent
500-10 Maths Year 11 Child
500-12 Maths Year 12 Child
Thanks in advance
@MYDATASTORY , see if this can help. You might have use path
Refer
https://community.powerbi.com/t5/Desktop/Dynamic-measure-calculation-for-hierarchy-data/td-p/592546
https://community.powerbi.com/t5/Desktop/How-to-create-column-and-row-hierarchies-in-tables/td-p/811...