Solved

How to build Asset hierarchy in Power BI [Community Contributed]

  • 24 March 2023
  • 6 replies
  • 122 views

Userlevel 1
Badge +1

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

icon

Best answer by Dilini Fernando 3 April 2023, 15:15

View original

6 replies

Userlevel 2
Badge

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

 

Userlevel 1
Badge +1

@Ankit Kumar  Thanks! This “Tree” visual is “Treemap” right? This will be feasible when we want to show heirarchy in chart however i want to show it as slicer in Power BI.

Something like this: below is excel manipulated data:

 

Userlevel 2
Badge

Have you tried Hierarchy Slicer Visual . here is the snap shot with Parent External ID and External ID in the fields section 
 

 

Userlevel 4
Badge +2

Hi @Paramale Arati,

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  

Userlevel 1
Badge +1

HI All,

 

Thank you for your responses. Please mark this case as solved.

 

Thanks!

Userlevel 4
Badge +2

Hi @Paramale Arati,

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 

 

Reply