Forum Discussion
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:-
| Employee | Country | Category | EmpId | Role |
| Preet | India | Laptop | 1 | Analyst |
| Age | Address | Gender | ||
| 45 | abc | M | ||
| Priya | US | Tablet | 2 | Accountant |
| Age | Address | Gender | ||
| 23 | abcd | F | ||
| Riya | US | Laptop | 3 | Engineer |
| Age | Address | Gender | ||
| 30 | abcde | F | ||
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
- shafiz_p
Super User
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 - AnonymousNot applicable
Hi NiharikaRaghav ,
The table does not support Drill Down, however the matrix can support Drill Down, please try. Also, Shahariar's approach is great.
Create a matrix visual in Power BI - Power BI | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.