Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Minimizing and Maximizing table rows(Kind of drilldown)

Hi Team,

    I have employee table where I have the Employee details like Id, Name, Location details, Role and Teamlead Id and TeamLead table where I have Id, Name, Location details, and Role.

My requirement is, initially I should show the Team lead Name, Location details, Role and Number of employees in his team and when I expand by clicking on that Teamlead, I should get the details of his employees Name, Location details, Role and 1 for Number of employees column.

Can we achieve this in Powerbi?

 

Sample Images

Initial table looks like this

When we expand the rows it should look like this

 

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Anonymous, the data looks similar to this.

      Expected results are 

       

      When we expand the rows it should look like this

       

       

       

      Team Lead Table 

      UserIdNameRole StateDistrictLocality
      EMP1002TL1BackendKarnatakaBengaluruWhitefield
      EMP1064TL2Full StackMaharastraMumbaiGoregaon
      EMP1012TL3DevOpsMaharastraMumbaiGoregaon
      EMP1068TL4AIKarnatakaBengaluruWhitefield
      EMP1048TL5BIKarnatakaBengaluru

      Whitefield

       

       

      Team Members table

      UserIdNameRole StateDistrictLocalityTeamLeadId
      EMP1111EMP Name 1BackendKarnatakaBengaluruWhitefieldEMP1002
      EMP1112EMP Name 2Full StackMaharastraMumbaiGoregaonEMP1064
      EMP1113EMP Name 3DevOpsMaharastraMumbaiGoregaonEMP1012
      EMP1114EMP Name 4AIKarnatakaBengaluruWhitefieldEMP1068
      EMP1115EMP Name 5BIKarnatakaBengaluruWhitefieldEMP1048
      EMP1116EMP Name 6BackendTelanganaHyderabadSecunderabadEMP1002
      EMP1117EMP Name 7Full StackMaharastraMumbaiGoregaonEMP1064
      EMP1118EMP Name 8DevOpsMaharastraMumbaiGoregaonEMP1012
      EMP1119EMP Name 9AITelanganaHyderabadHi-Tech CityEMP1068
      EMP1120EMP Name 10BackendMaharastraMumbaiGoregaonEMP1002
      EMP1121EMP Name 11Full StackTelanganaHyderabadSecunderabadEMP1064
      EMP1122EMP Name 12DevOpsMaharastraMumbaiGoregaonEMP1012
      EMP1123EMP Name 13AITelanganaHyderabadHi-Tech CityEMP1068
      EMP1124EMP Name 14BIKarnatakaBengaluruMarathahalliEMP1048
      EMP1125EMP Name 15BIKarnatakaBengaluruMarathahalliEMP1048
      EMP1126EMP Name 16BIKarnatakaBengaluruWhitefieldEMP1048
      EMP1127EMP Name 17AITelanganaHyderabadJubilee HillsEMP1068
      EMP1128EMP Name 18Full StackKarnatakaBengaluruMarathahalliEMP1064