Forum Discussion
Drill-Through using Column Names
Hello,
I am manage my companies training matrix and am trying to use PowerBI to make visualizing it easier. My idea is to have a list of the trainings on one page and drill through those to get to a table with each employees name and the date they completed that training. Does anyone have a recommendations for completing this task?
Here is a snip of part of the data.
daytonwinter TO make it work, you should Unpivot your data:
Transform Data -> Select Employee Column -> Right CLick -> Unpivot other columns
It will add two columns, attribute and value, rename these as you see fit.
Close and apply
Create a page with table visual and put attribute column in it, it will show all the training, add another page with employee and date column in it and in drill thru add ATTRIBUTE column
Go back to page 1, right click and it will show you 2nd page for drill thru and that's it. Read more about drill thru here Set up drillthrough in Power BI reports - Power BI | Microsoft Docs
✨ Follow us on LinkedIn and subscribe to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
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.⚡
3 Replies
daytonwinter TO make it work, you should Unpivot your data:
Transform Data -> Select Employee Column -> Right CLick -> Unpivot other columns
It will add two columns, attribute and value, rename these as you see fit.
Close and apply
Create a page with table visual and put attribute column in it, it will show all the training, add another page with employee and date column in it and in drill thru add ATTRIBUTE column
Go back to page 1, right click and it will show you 2nd page for drill thru and that's it. Read more about drill thru here Set up drillthrough in Power BI reports - Power BI | Microsoft Docs
✨ Follow us on LinkedIn and subscribe to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
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.⚡
This is exactly what I needed. Thanks!
daytonwinter awesone, glad it worked, subscribe to my youtube channel, you will some interesting tip and trick, link below.
✨ Follow us on LinkedIn and subscribe to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
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.⚡
