Hi Team,
I am facing one challenge in creating Asset hierarchy in Power BI. Format of data is not as per the required format for hierarchy creation i.e. i do not get parent-child relation in different columns. However i see all nodes appear in single column. I do have ParentID but unaware how this will help me to form hierarchy. Any inputs will be appreciated.
Thanks!
Regards,
Arati
Best answer by Dilini Fernando
Hi
I hope you were able to resolve the problem with Ankit's assistance. Please let us know if you have any other queries about PowerBI.
Best regards,
Dilini
Thats how the data model for Assets look like.. check for visual named “Tree” whiere you can provide the Parent external ids and the External Ids in the field section to view the hirerachy
Something like this: below is excel manipulated data:
Have you tried Hierarchy Slicer Visual . here is the snap shot with Parent External ID and External ID in the fields section
+2Hi
I hope you were able to resolve the problem with Ankit's assistance. Please let us know if you have any other queries about PowerBI.
Best regards,
Dilini
+2Hi
We appreciate your contribution to our community hub! We have chosen to move your article to our hub's How-To section as it will greatly benefit other members of our community. Thank you for your understanding, and we look forward to seeing more great contributions from you in the future!
Best regards,
Dilini
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Check the
documentation
Ask the
Community
Take a look
at
Academy
Cognite
Status
Page
Contact
Cognite Support
