Dataverse business unit hierarchy in power bi

[CanuckBuck]

I am brand new to Power BI (a few hours old).  I have many years of experience with Tableau.  I have a Dataverse database that I need to create some visulizations for (Which is why I'm using Power BI.  Tableau doesn't play nice with Dataverse, yet).  One of the things I need to visualize is the tree structure of our organization.  In fact, I want to use that tree as a mechanism to select related data.  The data is in the built-in Dataverse table called Business Unit.  The simplified structure of the table is;

Name	Parent Business	Hierarchy level
Enterprise	[NULL]
Division 1	Enterprise	1
Division 2	Enterprise	1
Division 3	Enterprise	1
Department 1	Division 1	2
Department 2	Division 1	2
Department 3	Division 2	2
Department 4	Division 3	2
Group 1	Department 1	3
Group 2	Department 1	3
Group 3	Department 4	3

And so on...  (Hierarchy level wasn't originally part of the Dataverse table definition.  I added it).

I need to know how to create an expand/collapse list of this structure and use the selected item in the list to filter other visuals.

How do I do that (in the spirit of full disclosure, I'd need to post to a Tableau forum to learn how to do this in Tableau too... :-))?

[amitchandak · Accepted solution]

@CanuckBuck , refer if Path and Path length can help

https://radacad.com/parsing-organizational-hierarchy-or-chart-of-accounts-in-power-bi-with-parent-ch...

[Anonymous · Accepted solution]

Hi @CanuckBuck 

You can also try using the native slicer visual. It can accept multiple columns to have a hierarchy in it. Use the slicer to select items in different hierarchies to filter other visuals. Here is a blog for your reference: How to Create an Organizational Hierarchy in Power BI?🔥 | by Gulce Ekin | Medium

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[amitchandak · Accepted solution]

@CanuckBuck , refer if Path and Path length can help

https://radacad.com/parsing-organizational-hierarchy-or-chart-of-accounts-in-power-bi-with-parent-ch...