Forum Discussion
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
- AnonymousNot 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
- AnonymousNot 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
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