Forum Discussion
Drill down should show additional columns.
I have a matrix visual on which I have to apply drill down.
My drill down hierarchy is employee->client.
Originally, the matrix visual has employee,firstdeptcode,firstofficecode,FeeWIP,AdvWIP,NetWip and Unbilled Hours.
When I drill down onto employee, it should show Client,ParentCode,ParentName,ClientCategory,FeeWIP,AdvWIP,NetWIP.
Is there any way by which we can show additional columns in drill down and hide columns which we don't want to show?
I would appreciate any suggestions and remarks.
Hi Anonymous
Drill down cannot add/delete columns in your visual .The function you need is Drill Through .
You can refer to the link below to configure drill through .
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
Anonymous it is not possible, you can think of using drill thru instead of drill down, on drill thru page you can show whatever you want, you cannot add//remove columns when you drill down.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Hi Anonymous
Drill down cannot add/delete columns in your visual .The function you need is Drill Through .
You can refer to the link below to configure drill through .
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous parry2k .
Yes I know that we can achieve the same using drill through, I just wanted to know whether there is any way to do it in drill down.
Anyways, thanks to both of you for replying.
amitchandak parry2k selimovd Fowmy
Can you guys help?Hey Anonymous ,
you can just put all the columns in the rows of the matrix that you want to drill down.
They don't have to be a hierarchy or something similar. The ones you don't need you can remove.
Does this help or did I miss something?
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicHi Anonymous
Unfortunately, drill down can't realize the function of automatically adding columns, it just drills down in the existing columns.
Has your problem been solved ? If it has been solved, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards
Community Support Team _ Ailsa Tao
