Minimizing and Maximizing table rows(Kind of drilldown)

[manishguduri]

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

[Anonymous]

Hi @manishguduri ,

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

[manishguduri]

Hi @Anonymous, the data looks similar to this.

Expected results are 

When we expand the rows it should look like this

Team Lead Table 

UserId	Name	Role	State	District	Locality
EMP1002	TL1	Backend	Karnataka	Bengaluru	Whitefield
EMP1064	TL2	Full Stack	Maharastra	Mumbai	Goregaon
EMP1012	TL3	DevOps	Maharastra	Mumbai	Goregaon
EMP1068	TL4	AI	Karnataka	Bengaluru	Whitefield
EMP1048	TL5	BI	Karnataka	Bengaluru	Whitefield

Team Members table

UserId	Name	Role	State	District	Locality	TeamLeadId
EMP1111	EMP Name 1	Backend	Karnataka	Bengaluru	Whitefield	EMP1002
EMP1112	EMP Name 2	Full Stack	Maharastra	Mumbai	Goregaon	EMP1064
EMP1113	EMP Name 3	DevOps	Maharastra	Mumbai	Goregaon	EMP1012
EMP1114	EMP Name 4	AI	Karnataka	Bengaluru	Whitefield	EMP1068
EMP1115	EMP Name 5	BI	Karnataka	Bengaluru	Whitefield	EMP1048
EMP1116	EMP Name 6	Backend	Telangana	Hyderabad	Secunderabad	EMP1002
EMP1117	EMP Name 7	Full Stack	Maharastra	Mumbai	Goregaon	EMP1064
EMP1118	EMP Name 8	DevOps	Maharastra	Mumbai	Goregaon	EMP1012
EMP1119	EMP Name 9	AI	Telangana	Hyderabad	Hi-Tech City	EMP1068
EMP1120	EMP Name 10	Backend	Maharastra	Mumbai	Goregaon	EMP1002
EMP1121	EMP Name 11	Full Stack	Telangana	Hyderabad	Secunderabad	EMP1064
EMP1122	EMP Name 12	DevOps	Maharastra	Mumbai	Goregaon	EMP1012
EMP1123	EMP Name 13	AI	Telangana	Hyderabad	Hi-Tech City	EMP1068
EMP1124	EMP Name 14	BI	Karnataka	Bengaluru	Marathahalli	EMP1048
EMP1125	EMP Name 15	BI	Karnataka	Bengaluru	Marathahalli	EMP1048
EMP1126	EMP Name 16	BI	Karnataka	Bengaluru	Whitefield	EMP1048
EMP1127	EMP Name 17	AI	Telangana	Hyderabad	Jubilee Hills	EMP1068
EMP1128	EMP Name 18	Full Stack	Karnataka	Bengaluru	Marathahalli	EMP1064