Forum Discussion

NiharikaRaghav's avatar
NiharikaRaghav
Frequent Visitor
2 years ago
Solved

Power BI Table Visual Drill Down

Hello,
Can someone help me with this-
I have to show drill down in Table Visual ,  Table Visual has Employee, Country, Category, EmpId and Role as Columns , now on clicing on Employee Preet its drill down option will enable and its Age, Address and Gender should be shown in single row as a new table and same for other Employees, attaching screenshot for refrence:-

EmployeeCountryCategoryEmpIdRole
PreetIndiaLaptop1Analyst
AgeAddressGender  
45abcM  
     
PriyaUSTablet2Accountant
AgeAddressGender  
23abcdF  
     
RiyaUSLaptop3Engineer
AgeAddressGender  
30abcdeF  
     
  • Hi NiharikaRaghav  Considering below image is your table:

     

     

    Create a new page for drilldown. Create table and change page information to drilldown:

     

    Place emploee in th Drill through from section:

     

    Now go to main page and table. Right click on employee name and you will see drill through option:

    And you are done.

    Hope this helps!!
    If this solved your problem, please accept it as a solution!!

    Best Regards,
    Shahariar Hafiz

2 Replies

  • Hi NiharikaRaghav  Considering below image is your table:

     

     

    Create a new page for drilldown. Create table and change page information to drilldown:

     

    Place emploee in th Drill through from section:

     

    Now go to main page and table. Right click on employee name and you will see drill through option:

    And you are done.

    Hope this helps!!
    If this solved your problem, please accept it as a solution!!

    Best Regards,
    Shahariar Hafiz