Forum Discussion

vsatamraju's avatar
vsatamraju
Microsoft Employee
10 years ago

Creating a Hierarchy in Power BI

Hi All,

 

We are Clustered Column Chart in Power BI.

We are implementing the drill down feature for employee heirarchy from top to bottom according to the Organization depth. Now we want to show the Count of direct as well as indirect for each manager.

 

How can we do this ?

 

Thanks in Advance

11 Replies

  • ankitpatira's avatar
    ankitpatira
    Community Champion
    10 years ago

    vsatamraju to be able to create drill down in power bi visuals you need to drop multiple fields into Axis area. provided you have columns of organisational level, manager and count of employees you can use Pivot column feature in query editor in power bi desktop to seperate out organisational level as individual columns. you can then drop those fields into Axis area and count of employees onto Value area. 

     

    The way you operate this depends on the structure of your data.

  • Habib's avatar
    Habib
    Continued Contributor
    10 years ago

    You need help regarding hierarchy creation or to show the count for direct/indirect?

      • vsatamraju's avatar
        vsatamraju
        Microsoft Employee
        10 years ago

        Sorry ,its a type mistake.

         

        We are looing for Count of employees under each manager direct and indirect reportees.

         

        Thanks in Advance